{"text_format":"1","workbook":"xlsx","n_sheets":43,"sheets":["Summary #1","Summary #2","Summary #3","Summary #4","Ticket Sales","Ticket Plans","Guarantees-Rev","Contributions","3rd Party Comp","NCAA-Conference","Broadcast Rights","Event Sales","Royalties","Sports Camps","Endowment&Investment","Other Revenue","Student Fees","State-Government Support","General Fund","Indirect Inst. Support","Athletic Aid","Coaching Salaries","Coaching Comp.","Support Salaries","Support Comp.","Severance","Recruiting","Team Travel","Equipment","Game Expenses","Officials","Medical Expenses","Guarantees-Exp","Direct Facilities","Indirect Facilities","Fundraising","Sports Camp Exp.","Spirit Groups","Memberships & Dues","Other Expenses","Rev.vs. Exp","Graphs","Empty Sheet"],"not_rendered":{"charts":35,"images":1,"macros":1,"external_links":0,"defined_names":39,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Summary #1","index":0,"n_rows":63,"n_cols":9,"rows_kept":63,"cut":false,"hidden":false,"merged":[[0,1,0,8]]}
[null,"Summary of Revenues and Expenses-Poole University"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Year 2","Year 3","Year 4","Year 5"]
["Revenues-Generated"]
["Ticket Sales",{"$f":"'Ticket Sales'!$B$36","v":11626850},{"$f":"'Ticket Sales'!$C$36","v":13358150},{"$f":"SUM('Ticket Sales'!D36)","v":11814600},{"$f":"SUM('Ticket Sales'!E36)","v":13619000},{"$f":"SUM('Ticket Sales'!G36)","v":13905600},{"$f":"SUM('Ticket Sales'!I36)","v":14532400},{"$f":"SUM('Ticket Sales'!K36)","v":15248600},{"$f":"SUM('Ticket Sales'!M36)","v":15925700}]
["Guarantees",{"$f":"SUM('Guarantees-Rev'!B13)","v":218000},{"$f":"SUM('Guarantees-Rev'!C13)","v":420500},{"$f":"SUM('Guarantees-Rev'!D13)","v":347000},{"$f":"SUM('Guarantees-Rev'!E13)","v":459300},{"$f":"SUM('Guarantees-Rev'!G13)","v":482300},{"$f":"SUM('Guarantees-Rev'!I13)","v":506500},{"$f":"SUM('Guarantees-Rev'!K13)","v":531900},{"$f":"SUM('Guarantees-Rev'!M13)","v":574400}]
["Contributions",{"$f":"SUM(Contributions!B38)","v":563200},{"$f":"SUM(Contributions!C38)","v":579500},{"$f":"SUM(Contributions!D38)","v":556800},{"$f":"SUM(Contributions!E38)","v":575500},{"$f":"SUM(Contributions!G38)","v":608900},{"$f":"SUM(Contributions!I38)","v":627300},{"$f":"SUM(Contributions!K38)","v":658900},{"$f":"SUM(Contributions!M38)","v":693200}]
["3rd Party Compensation",{"$f":"SUM('3rd Party Comp'!B35)","v":39000},{"$f":"SUM('3rd Party Comp'!C35)","v":38000},{"$f":"SUM('3rd Party Comp'!D35)","v":100000},{"$f":"SUM('3rd Party Comp'!E35)","v":39000},{"$f":"SUM('3rd Party Comp'!G35)","v":39000},{"$f":"SUM('3rd Party Comp'!I35)","v":39000},{"$f":"SUM('3rd Party Comp'!K35)","v":39000},{"$f":"SUM('3rd Party Comp'!M35)","v":39000}]
["NCAA/Conference Distributions",{"$f":"SUM('NCAA-Conference'!B14)","v":306000},{"$f":"SUM('NCAA-Conference'!C14)","v":317500},{"$f":"SUM('NCAA-Conference'!D14)","v":293000},{"$f":"SUM('NCAA-Conference'!E14)","v":332800},{"$f":"SUM('NCAA-Conference'!G14)","v":348800},{"$f":"SUM('NCAA-Conference'!I14)","v":365600},{"$f":"SUM('NCAA-Conference'!K14)","v":400600},{"$f":"SUM('NCAA-Conference'!M14)","v":439000}]
["Broadcast Rights",{"$f":"SUM('Broadcast Rights'!B10)","v":29500},{"$f":"SUM('Broadcast Rights'!C10)","v":35000},{"$f":"SUM('Broadcast Rights'!D10)","v":28000},{"$f":"SUM('Broadcast Rights'!E10)","v":37000},{"$f":"SUM('Broadcast Rights'!G10)","v":39100},{"$f":"SUM('Broadcast Rights'!I10)","v":41300},{"$f":"SUM('Broadcast Rights'!K10)","v":43700},{"$f":"SUM('Broadcast Rights'!M10)","v":46100}]
["Event Sales",{"$f":"SUM('Event Sales'!B11)","v":8350},{"$f":"SUM('Event Sales'!C11)","v":9000},{"$f":"SUM('Event Sales'!D11)","v":6500},{"$f":"SUM('Event Sales'!E11)","v":9000},{"$f":"SUM('Event Sales'!G11)","v":9000},{"$f":"SUM('Event Sales'!I11)","v":9000},{"$f":"SUM('Event Sales'!K11)","v":9000},{"$f":"SUM('Event Sales'!M11)","v":9000}]
["Royalties",{"$f":"SUM(Royalties!B12)","v":377400},{"$f":"SUM(Royalties!C12)","v":393000},{"$f":"SUM(Royalties!D12)","v":356000},{"$f":"SUM(Royalties!E12)","v":419700},{"$f":"SUM(Royalties!G12)","v":455300},{"$f":"SUM(Royalties!I12)","v":494200},{"$f":"SUM(Royalties!K12)","v":536700},{"$f":"SUM(Royalties!M12)","v":583000}]
["Sports Camp Revenues",{"$f":"SUM('Sports Camps'!B40)","v":239450},{"$f":"SUM('Sports Camps'!C40)","v":269700},{"$f":"SUM('Sports Camps'!D40)","v":238000},{"$f":"SUM('Sports Camps'!E40)","v":283100},{"$f":"SUM('Sports Camps'!G40)","v":297400},{"$f":"SUM('Sports Camps'!I40)","v":312300},{"$f":"SUM('Sports Camps'!K40)","v":328000},{"$f":"SUM('Sports Camps'!M40)","v":360600}]
["Endowment and Investment Income",{"$f":"SUM('Endowment&Investment'!B10)","v":0},{"$f":"SUM('Endowment&Investment'!C10)","v":0},{"$f":"SUM('Endowment&Investment'!D10)","v":0},{"$f":"SUM('Endowment&Investment'!E10)","v":0},{"$f":"SUM('Endowment&Investment'!G10)","v":0},{"$f":"SUM('Endowment&Investment'!I10)","v":0},{"$f":"SUM('Endowment&Investment'!K10)","v":0},{"$f":"SUM('Endowment&Investment'!M10)","v":0}]
["Other*",{"$f":"SUM('Other Revenue'!B10)","v":0},{"$f":"SUM('Other Revenue'!C10)","v":0},{"$f":"SUM('Other Revenue'!D10)","v":0},{"$f":"SUM('Other Revenue'!E10)","v":0},{"$f":"SUM('Other Revenue'!G10)","v":0},{"$f":"SUM('Other Revenue'!I10)","v":0},{"$f":"SUM('Other Revenue'!K10)","v":0},{"$f":"SUM('Other Revenue'!M10)","v":0}]
["Subtotal-Generated Revenues",{"$f":"SUM(B5:B15)","v":13407750},15420350,{"$f":"SUM(D5:D15)","v":13739900},15774400,16185400,16927600,17796400,18670000]
[]
["Revenues-Allocated"]
["Student Athletic Fees",{"$f":"SUM('Student Fees'!B8)","v":3010000},{"$f":"SUM('Student Fees'!C8)","v":3030500},{"$f":"SUM('Student Fees'!D8)","v":2900000},{"$f":"SUM('Student Fees'!E8)","v":3227500},{"$f":"SUM('Student Fees'!G8)","v":3437300},{"$f":"SUM('Student Fees'!I8)","v":3660700},{"$f":"SUM('Student Fees'!K8)","v":3862000},{"$f":"SUM('Student Fees'!M8)","v":4132300}]
["State/Government Support",{"$f":"SUM('State-Government Support'!B10)","v":0},{"$f":"SUM('State-Government Support'!C10)","v":0},{"$f":"SUM('State-Government Support'!D10)","v":0},{"$f":"SUM('State-Government Support'!E10)","v":0},{"$f":"SUM('State-Government Support'!G10)","v":0},{"$f":"SUM('State-Government Support'!I10)","v":0},{"$f":"SUM('State-Government Support'!K10)","v":0},{"$f":"SUM('State-Government Support'!M10)","v":0}]
["General Fund (Institutional) Support",{"$f":"SUM('General Fund'!$B$12)","v":2050000},{"$f":"SUM('General Fund'!$C$12)","v":2161000},{"$f":"SUM('General Fund'!D12)","v":1945000},{"$f":"SUM('General Fund'!$E$12)","v":2269100},{"$f":"SUM('General Fund'!$G$12)","v":2382500},{"$f":"SUM('General Fund'!$I$12)","v":2501700},{"$f":"SUM('General Fund'!$K$12)","v":2603600},{"$f":"SUM('General Fund'!M12)","v":2709700}]
["Indirect Institutional Support",{"$f":"SUM('Indirect Inst. Support'!B15)","v":105100},{"$f":"SUM('Indirect Inst. Support'!C15)","v":105400},{"$f":"SUM('Indirect Inst. Support'!D15)","v":89500},{"$f":"SUM('Indirect Inst. Support'!E15)","v":106400},{"$f":"SUM('Indirect Inst. Support'!G15)","v":107400},{"$f":"SUM('Indirect Inst. Support'!I15)","v":111700},{"$f":"SUM('Indirect Inst. Support'!K15)","v":116200},{"$f":"SUM('Indirect Inst. Support'!M15)","v":120900}]
["Subtotal Allocated Revenues",{"$f":"SUM(B19:B22)","v":5165100},5296900,{"$f":"SUM(D19:D22)","v":4934500},5603000,5927200,6274100,6581800,6962900]
["Total Revenues",{"$f":"B16+B23","v":18572850},20717250,{"$f":"D16+D23","v":18674400},21377400,22112600,23201700,24378200,25632900]
[]
["Expenses"]
["Student"]
["Athletic Student Aid",{"$f":"SUM('Athletic Aid'!B47)","v":2261000},{"$f":"SUM('Athletic Aid'!C47)","v":2928000},{"$f":"SUM('Athletic Aid'!D47)","v":2655000},{"$f":"SUM('Athletic Aid'!E47)","v":2998100},{"$f":"SUM('Athletic Aid'!G47)","v":3072800},{"$f":"SUM('Athletic Aid'!I47)","v":3149300},{"$f":"SUM('Athletic Aid'!K47)","v":3228100},{"$f":"SUM('Athletic Aid'!M47)","v":3309000}]
[]
["Salaries & Benefits"]
["Coaching Salaries, Benefits, Bonuses",{"$f":"SUM('Coaching Salaries'!B201)","v":6059460},{"$f":"SUM('Coaching Salaries'!C201)","v":6382500},{"$f":"SUM('Coaching Salaries'!D201)","v":5271860},{"$f":"SUM('Coaching Salaries'!E201)","v":6697000},{"$f":"SUM('Coaching Salaries'!G201)","v":7026800},{"$f":"SUM('Coaching Salaries'!I201)","v":7373100},{"$f":"SUM('Coaching Salaries'!K201)","v":7736400},{"$f":"SUM('Coaching Salaries'!M201)","v":8118100}]
["Coaching Compensation & Benefits  Paid by Third Party",{"$f":"SUM('Coaching Comp.'!B36)","v":37000},{"$f":"SUM('Coaching Comp.'!C36)","v":175000},{"$f":"SUM('Coaching Comp.'!D36)","v":25000},{"$f":"SUM('Coaching Comp.'!E36)","v":136300},{"$f":"SUM('Coaching Comp.'!G36)","v":141400},{"$f":"SUM('Coaching Comp.'!I36)","v":146700},{"$f":"SUM('Coaching Comp.'!K36)","v":152200},{"$f":"SUM('Coaching Comp.'!M36)","v":158000}]
["Support Staff/Administrative Salaries, Benefits, Bonuses",{"$f":"SUM('Support Salaries'!B72)","v":3811000},{"$f":"SUM('Support Salaries'!C72)","v":4181000},{"$f":"SUM('Support Salaries'!D72)","v":4002000},{"$f":"SUM('Support Salaries'!E72)","v":4297600},{"$f":"SUM('Support Salaries'!G72)","v":4507300},{"$f":"SUM('Support Salaries'!I72)","v":4727700},{"$f":"SUM('Support Salaries'!K72)","v":4959200},{"$f":"SUM('Support Salaries'!M72)","v":5202400}]
["Support Staff/Administrative Compenstation & Benefits Paid by Third Party",{"$f":"SUM('Support Comp.'!B20)","v":0},{"$f":"SUM('Support Comp.'!C20)","v":0},{"$f":"SUM('Support Comp.'!D20)","v":0},{"$f":"SUM('Support Comp.'!E20)","v":0},{"$f":"SUM('Support Comp.'!G20)","v":0},{"$f":"SUM('Support Comp.'!I20)","v":0},{"$f":"SUM('Support Comp.'!K20)","v":0},{"$f":"SUM('Support Comp.'!M20)","v":0}]
["Severance Payments",{"$f":"SUM(Severance!B10)","v":0},{"$f":"SUM(Severance!C10)","v":100000},{"$f":"SUM(Severance!D10)","v":100000},{"$f":"SUM(Severance!E10)","v":100000},{"$f":"SUM(Severance!G10)","v":100000},{"$f":"SUM(Severance!I10)","v":100000},{"$f":"SUM(Severance!K10)","v":100000},{"$f":"SUM(Severance!M10)","v":100000}]
["Subtotal Salaries & Benefits",{"$f":"SUM(B31:B35)","v":9907460},10838500,{"$f":"SUM(D31:D35)","v":9398860},11230900,11775500,12347500,12947800,13578500]
[]
["Participation and Game Expenses"]
["Recruiting",{"$f":"SUM(Recruiting!B37)","v":467880},{"$f":"SUM(Recruiting!C37)","v":513885},{"$f":"SUM(Recruiting!D37)","v":482100},{"$f":"SUM(Recruiting!E37)","v":546100},{"$f":"SUM(Recruiting!G37)","v":580500},{"$f":"SUM(Recruiting!I37)","v":617300},{"$f":"SUM(Recruiting!K37)","v":656800},{"$f":"SUM(Recruiting!M37)","v":699000}]
["Team Travel",{"$f":"SUM('Team Travel'!B39)","v":2393700},{"$f":"SUM('Team Travel'!C39)","v":2550000},{"$f":"SUM('Team Travel'!D39)","v":2288300},{"$f":"SUM('Team Travel'!E39)","v":2829000},{"$f":"SUM('Team Travel'!G39)","v":2964500},{"$f":"SUM('Team Travel'!I39)","v":3106800},{"$f":"SUM('Team Travel'!K39)","v":3256100},{"$f":"SUM('Team Travel'!M39)","v":3412900}]
["Equipment, Uniforms and Supplies",{"$f":"SUM(Equipment!B39)","v":540000},{"$f":"SUM(Equipment!C39)","v":585500},{"$f":"SUM(Equipment!D39)","v":502000},{"$f":"SUM(Equipment!E39)","v":654900},{"$f":"SUM(Equipment!G39)","v":674600},{"$f":"SUM(Equipment!I39)","v":694900},{"$f":"SUM(Equipment!K39)","v":715700},{"$f":"SUM(Equipment!M39)","v":737200}]
["Game Expenses",{"$f":"SUM('Game Expenses'!B10)","v":665000},{"$f":"SUM('Game Expenses'!C10)","v":737850},{"$f":"SUM('Game Expenses'!D10)","v":661300},{"$f":"SUM('Game Expenses'!E10)","v":736400},{"$f":"SUM('Game Expenses'!G10)","v":783300},{"$f":"SUM('Game Expenses'!I10)","v":834800},{"$f":"SUM('Game Expenses'!K10)","v":891700},{"$f":"SUM('Game Expenses'!M10)","v":954800}]
["Medical Expenses & Insurance",{"$f":"SUM('Medical Expenses'!B9)","v":480000},{"$f":"SUM('Medical Expenses'!C9)","v":552000},{"$f":"SUM('Medical Expenses'!D9)","v":450000},{"$f":"SUM('Medical Expenses'!E9)","v":599700},{"$f":"SUM('Medical Expenses'!G9)","v":651800},{"$f":"SUM('Medical Expenses'!I9)","v":708700},{"$f":"SUM('Medical Expenses'!K9)","v":770900},{"$f":"SUM('Medical Expenses'!M9)","v":838900}]
["Guarantees",{"$f":"SUM('Guarantees-Exp'!B14)","v":320000},{"$f":"SUM('Guarantees-Exp'!C14)","v":360000},{"$f":"SUM('Guarantees-Exp'!D14)","v":340000},{"$f":"SUM('Guarantees-Exp'!E14)","v":378000},{"$f":"SUM('Guarantees-Exp'!G14)","v":396900},{"$f":"SUM('Guarantees-Exp'!I14)","v":416800},{"$f":"SUM('Guarantees-Exp'!K14)","v":425200},{"$f":"SUM('Guarantees-Exp'!M14)","v":433800}]
["Subtotal Participation & Game Expenses",{"$f":"SUM(B39:B44)","v":4866580},5299235,{"$f":"SUM(D39:D44)","v":4723700},5744100,6051600,6379300,6716400,7076600]
[]
["Facilities Maintenance & Adminstrative Support"]
["Direct Facilities, Maintenance and Rental",{"$f":"SUM('Direct Facilities'!B13)","v":812800},{"$f":"SUM('Direct Facilities'!C13)","v":895000},{"$f":"SUM('Direct Facilities'!$D$13)","v":721000},{"$f":"SUM('Direct Facilities'!E13)","v":1069800},{"$f":"SUM('Direct Facilities'!G13)","v":1102000},{"$f":"SUM('Direct Facilities'!I13)","v":1135100},{"$f":"SUM('Direct Facilities'!K13)","v":1169100},{"$f":"SUM('Direct Facilities'!M13)","v":1204100}]
["Indirect Facilities and Administrative Support",{"$f":"SUM('Indirect Facilities'!B15)","v":100000},{"$f":"SUM('Indirect Facilities'!C15)","v":100000},{"$f":"SUM('Indirect Facilities'!D15)","v":90000},{"$f":"SUM('Indirect Facilities'!E15)","v":110000},{"$f":"SUM('Indirect Facilities'!G15)","v":165000},{"$f":"SUM('Indirect Facilities'!I15)","v":247500},{"$f":"SUM('Indirect Facilities'!K15)","v":371300},{"$f":"SUM('Indirect Facilities'!M15)","v":519800}]
["Subtotal Facilities, Maintenance & Adminstrative Support",{"$f":"SUM(B48:B49)","v":912800},995000,{"$f":"SUM(D48:D49)","v":811000},1179800,1267000,1382600,1540400,1723900]
[]
["Miscellaneous"]
["Fundraising, Marketing and Promotion",{"$f":"SUM(Fundraising!B12)","v":158500},{"$f":"SUM(Fundraising!C12)","v":205000},{"$f":"SUM(Fundraising!D12)","v":153000},{"$f":"SUM(Fundraising!E12)","v":217800},{"$f":"SUM(Fundraising!G12)","v":231500},{"$f":"SUM(Fundraising!I12)","v":246200},{"$f":"SUM(Fundraising!K12)","v":261800},{"$f":"SUM(Fundraising!M12)","v":278500}]
["Sports Camp Expenses",{"$f":"SUM('Sports Camp Exp.'!B42)","v":196200},{"$f":"SUM('Sports Camp Exp.'!C42)","v":249700},{"$f":"SUM('Sports Camp Exp.'!D42)","v":191000},{"$f":"SUM('Sports Camp Exp.'!E42)","v":262300},{"$f":"SUM('Sports Camp Exp.'!G42)","v":275400},{"$f":"SUM('Sports Camp Exp.'!I42)","v":289100},{"$f":"SUM('Sports Camp Exp.'!K42)","v":303600},{"$f":"SUM('Sports Camp Exp.'!M42)","v":318900}]
["Spirt Groups",{"$f":"SUM('Spirit Groups'!B12)","v":18300},{"$f":"SUM('Spirit Groups'!C12)","v":22000},{"$f":"SUM('Spirit Groups'!D12)","v":16300},{"$f":"SUM('Spirit Groups'!E12)","v":23200},{"$f":"SUM('Spirit Groups'!G12)","v":24400},{"$f":"SUM('Spirit Groups'!I12)","v":25700},{"$f":"SUM('Spirit Groups'!K12)","v":27000},{"$f":"SUM('Spirit Groups'!M12)","v":28400}]
["Memberships & Dues",{"$f":"SUM('Memberships & Dues'!B40)","v":120650},{"$f":"SUM('Memberships & Dues'!C40)","v":158050},{"$f":"SUM('Memberships & Dues'!D40)","v":149100},{"$f":"SUM('Memberships & Dues'!E40)","v":164500},{"$f":"SUM('Memberships & Dues'!G40)","v":171300},{"$f":"SUM('Memberships & Dues'!I40)","v":178400},{"$f":"SUM('Memberships & Dues'!K40)","v":185900},{"$f":"SUM('Memberships & Dues'!M40)","v":193800}]
["Other Operating Expenses*",{"$f":"SUM('Other Expenses'!B11)","v":0},{"$f":"SUM('Other Expenses'!C11)","v":0},{"$f":"SUM('Other Expenses'!D11)","v":0},{"$f":"SUM('Other Expenses'!E11)","v":0},{"$f":"SUM('Other Expenses'!G11)","v":0},{"$f":"SUM('Other Expenses'!I11)","v":0},{"$f":"SUM('Other Expenses'!K11)","v":0},{"$f":"SUM('Other Expenses'!M11)","v":0}]
["Subtotal Miscellaneous",{"$f":"SUM(B53:B57)","v":493650},634750,{"$f":"SUM(D53:D57)","v":509400},667800,702600,739400,778300,819600]
["Total-Expenses",{"$f":"B28+B36+B45+B50+B58","v":18441490},20695485,{"$f":"D28+D36+D45+D50+D58","v":18097960},21820700,22869500,23998100,25211000,26507600]
[]
["*Must not be more than 5% of total revenues/expenses"]
[]
["Total Revenues - Total Expenses",{"$f":"B24-B59","v":131360},21765,{"$f":"D24-D59","v":576440},-443300,-756900,-796400,-832800,-874700]

{"sheet":"Summary #2","index":1,"n_rows":40,"n_cols":9,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,1,0,8]]}
[null,"Summary of Cash Only Line Items"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Year 2","Year 3","Year 4","Year 5"]
[]
["Revenues"]
["Ticket Sales",{"$f":"SUM('Ticket Sales'!B36)","v":11626850},{"$f":"SUM('Ticket Sales'!C36)","v":13358150},{"$f":"SUM('Ticket Sales'!D36)","v":11814600},{"$f":"SUM('Ticket Sales'!E36)","v":13619000},{"$f":"SUM('Ticket Sales'!G36)","v":13905600},{"$f":"SUM('Ticket Sales'!I36)","v":14532400},{"$f":"SUM('Ticket Sales'!K36)","v":15248600},{"$f":"SUM('Ticket Sales'!M36)","v":15925700}]
["Guarantees",{"$f":"SUM('Guarantees-Rev'!B13)","v":218000},{"$f":"SUM('Guarantees-Rev'!C13)","v":420500},{"$f":"SUM('Guarantees-Rev'!D13)","v":347000},{"$f":"SUM('Guarantees-Rev'!E13)","v":459300},{"$f":"SUM('Guarantees-Rev'!G13)","v":482300},{"$f":"SUM('Guarantees-Rev'!I13)","v":506500},{"$f":"SUM('Guarantees-Rev'!K13)","v":531900},{"$f":"SUM('Guarantees-Rev'!M13)","v":574400}]
["Contributions",{"$f":"SUM(Contributions!B40)","v":560000},{"$f":"SUM(Contributions!C40)","v":576000},{"$f":"SUM(Contributions!D40)","v":554000},{"$f":"SUM(Contributions!E40)","v":571800},{"$f":"SUM(Contributions!G40)","v":605200},{"$f":"SUM(Contributions!I40)","v":623600},{"$f":"SUM(Contributions!K40)","v":655200},{"$f":"SUM(Contributions!M40)","v":689500}]
["NCAA Conference Distributions",{"$f":"SUM('NCAA-Conference'!B14)","v":306000},{"$f":"SUM('NCAA-Conference'!C14)","v":317500},{"$f":"SUM('NCAA-Conference'!D14)","v":293000},{"$f":"SUM('NCAA-Conference'!E14)","v":332800},{"$f":"SUM('NCAA-Conference'!G14)","v":348800},{"$f":"SUM('NCAA-Conference'!I14)","v":365600},{"$f":"SUM('NCAA-Conference'!K14)","v":400600},{"$f":"SUM('NCAA-Conference'!M14)","v":439000}]
["Broadcast Rights",{"$f":"SUM('Broadcast Rights'!B10)","v":29500},{"$f":"SUM('Broadcast Rights'!C10)","v":35000},{"$f":"SUM('Broadcast Rights'!D10)","v":28000},{"$f":"SUM('Broadcast Rights'!E10)","v":37000},{"$f":"SUM('Broadcast Rights'!G10)","v":39100},{"$f":"SUM('Broadcast Rights'!I10)","v":41300},{"$f":"SUM('Broadcast Rights'!K10)","v":43700},{"$f":"SUM('Broadcast Rights'!M10)","v":46100}]
["Event Sales",{"$f":"SUM('Event Sales'!B11)","v":8350},{"$f":"SUM('Event Sales'!C11)","v":9000},{"$f":"SUM('Event Sales'!D11)","v":6500},{"$f":"SUM('Event Sales'!E11)","v":9000},{"$f":"SUM('Event Sales'!G11)","v":9000},{"$f":"SUM('Event Sales'!I11)","v":9000},{"$f":"SUM('Event Sales'!K11)","v":9000},{"$f":"SUM('Event Sales'!M11)","v":9000}]
["Royalties",{"$f":"SUM(Royalties!B14)","v":295400},{"$f":"SUM(Royalties!C14)","v":302000},{"$f":"SUM(Royalties!D14)","v":276000},{"$f":"SUM(Royalties!E14)","v":324100},{"$f":"SUM(Royalties!G14)","v":354900},{"$f":"SUM(Royalties!I14)","v":388800},{"$f":"SUM(Royalties!K14)","v":426000},{"$f":"SUM(Royalties!M14)","v":466800}]
["Sports Camps",{"$f":"SUM('Sports Camps'!B40)","v":239450},{"$f":"SUM('Sports Camps'!C40)","v":269700},{"$f":"SUM('Sports Camps'!D40)","v":238000},{"$f":"SUM('Sports Camps'!E40)","v":283100},{"$f":"SUM('Sports Camps'!G40)","v":297400},{"$f":"SUM('Sports Camps'!I40)","v":312300},{"$f":"SUM('Sports Camps'!K40)","v":328000},{"$f":"SUM('Sports Camps'!M40)","v":360600}]
["Endowment & Investments",{"$f":"SUM('Endowment&Investment'!B10)","v":0},{"$f":"SUM('Endowment&Investment'!C10)","v":0},{"$f":"SUM('Endowment&Investment'!D10)","v":0},{"$f":"SUM('Endowment&Investment'!E10)","v":0},{"$f":"SUM('Endowment&Investment'!G10)","v":0},{"$f":"SUM('Endowment&Investment'!I10)","v":0},{"$f":"SUM('Endowment&Investment'!K10)","v":0},{"$f":"SUM('Endowment&Investment'!M10)","v":0}]
["Other",{"$f":"SUM('Other Revenue'!B10)","v":0},{"$f":"SUM('Other Revenue'!C10)","v":0},{"$f":"SUM('Other Revenue'!D10)","v":0},{"$f":"SUM('Other Revenue'!E10)","v":0},{"$f":"SUM('Other Revenue'!G10)","v":0},{"$f":"SUM('Other Revenue'!I10)","v":0},{"$f":"SUM('Other Revenue'!K10)","v":0},{"$f":"SUM('Other Revenue'!M10)","v":0}]
["Student Athletic Fees",{"$f":"SUM('Student Fees'!B8)","v":3010000},{"$f":"SUM('Student Fees'!C8)","v":3030500},{"$f":"SUM('Student Fees'!D8)","v":2900000},{"$f":"SUM('Student Fees'!E8)","v":3227500},{"$f":"SUM('Student Fees'!G8)","v":3437300},{"$f":"SUM('Student Fees'!I8)","v":3660700},{"$f":"SUM('Student Fees'!K8)","v":3862000},{"$f":"SUM('Student Fees'!M8)","v":4132300}]
["State-Government Support",{"$f":"SUM('State-Government Support'!B10)","v":0},{"$f":"SUM('State-Government Support'!C10)","v":0},{"$f":"SUM('State-Government Support'!D10)","v":0},{"$f":"SUM('State-Government Support'!E10)","v":0},{"$f":"SUM('State-Government Support'!G10)","v":0},{"$f":"SUM('State-Government Support'!I10)","v":0},{"$f":"SUM('State-Government Support'!K10)","v":0},{"$f":"SUM('State-Government Support'!M10)","v":0}]
["General Fund",{"$f":"SUM('General Fund'!B12)","v":2050000},{"$f":"SUM('General Fund'!C12)","v":2161000},{"$f":"SUM('General Fund'!D12)","v":1945000},{"$f":"SUM('General Fund'!E12)","v":2269100},{"$f":"SUM('General Fund'!G12)","v":2382500},{"$f":"SUM('General Fund'!I12)","v":2501700},{"$f":"SUM('General Fund'!K12)","v":2603600},{"$f":"SUM('General Fund'!M12)","v":2709700}]
["Total Cash Only Revenues",{"$f":"SUM(B6:B18)","v":18343550},20479350,18402100,21132700,21862100,22941900,24108600,25353100]
[]
["Expenses"]
["Athletic Student Aid",{"$f":"SUM('Athletic Aid'!B47)","v":2261000},{"$f":"SUM('Athletic Aid'!C47)","v":2928000},{"$f":"SUM('Athletic Aid'!D47)","v":2655000},{"$f":"SUM('Athletic Aid'!E47)","v":2998100},{"$f":"SUM('Athletic Aid'!G47)","v":3072800},{"$f":"SUM('Athletic Aid'!I47)","v":3149300},{"$f":"SUM('Athletic Aid'!K47)","v":3228100},{"$f":"SUM('Athletic Aid'!M47)","v":3309000}]
["Coaching Salaries",{"$f":"SUM('Coaching Salaries'!B201)","v":6059460},{"$f":"SUM('Coaching Salaries'!C201)","v":6382500},{"$f":"SUM('Coaching Salaries'!D201)","v":5271860},{"$f":"SUM('Coaching Salaries'!E201)","v":6697000},{"$f":"SUM('Coaching Salaries'!G201)","v":7026800},{"$f":"SUM('Coaching Salaries'!I201)","v":7373100},{"$f":"SUM('Coaching Salaries'!K201)","v":7736400},{"$f":"SUM('Coaching Salaries'!M201)","v":8118100}]
["Support Staff Salaries",{"$f":"SUM('Support Salaries'!B72)","v":3811000},{"$f":"SUM('Support Salaries'!C72)","v":4181000},{"$f":"SUM('Support Salaries'!D72)","v":4002000},{"$f":"SUM('Support Salaries'!E72)","v":4297600},{"$f":"SUM('Support Salaries'!G72)","v":4507300},{"$f":"SUM('Support Salaries'!I72)","v":4727700},{"$f":"SUM('Support Salaries'!K72)","v":4959200},{"$f":"SUM('Support Salaries'!M72)","v":5202400}]
["Severance",{"$f":"SUM(Severance!B10)","v":0},{"$f":"SUM(Severance!C10)","v":100000},{"$f":"SUM(Severance!D10)","v":100000},{"$f":"SUM(Severance!E10)","v":100000},{"$f":"SUM(Severance!G10)","v":100000},{"$f":"SUM(Severance!I10)","v":100000},{"$f":"SUM(Severance!K10)","v":100000},{"$f":"SUM(Severance!M10)","v":100000}]
["Recruiting",{"$f":"SUM(Recruiting!B40)","v":466480},{"$f":"SUM(Recruiting!C40)","v":512185},{"$f":"SUM(Recruiting!D40)","v":480700},{"$f":"SUM(Recruiting!E40)","v":544400},{"$f":"SUM(Recruiting!G40)","v":578800},{"$f":"SUM(Recruiting!I40)","v":615600},{"$f":"SUM(Recruiting!K40)","v":655100},{"$f":"SUM(Recruiting!M40)","v":697300}]
["Team Travel",{"$f":"SUM('Team Travel'!B42)","v":2386400},{"$f":"SUM('Team Travel'!C42)","v":2542450},{"$f":"SUM('Team Travel'!D42)","v":2281400},{"$f":"SUM('Team Travel'!E42)","v":2821100},{"$f":"SUM('Team Travel'!G42)","v":2956200},{"$f":"SUM('Team Travel'!I42)","v":3098100},{"$f":"SUM('Team Travel'!K42)","v":3247000},{"$f":"SUM('Team Travel'!M42)","v":3403300}]
["Equipment",{"$f":"SUM(Equipment!B43)","v":467000},{"$f":"SUM(Equipment!C43)","v":505500},{"$f":"SUM(Equipment!D43)","v":429000},{"$f":"SUM(Equipment!E43)","v":572500},{"$f":"SUM(Equipment!G43)","v":589800},{"$f":"SUM(Equipment!I43)","v":607500},{"$f":"SUM(Equipment!K43)","v":625700},{"$f":"SUM(Equipment!M43)","v":644500}]
["Game Expenses",{"$f":"SUM('Game Expenses'!B10)","v":665000},{"$f":"SUM('Game Expenses'!C10)","v":737850},{"$f":"SUM('Game Expenses'!D10)","v":661300},{"$f":"SUM('Game Expenses'!E10)","v":736400},{"$f":"SUM('Game Expenses'!G10)","v":783300},{"$f":"SUM('Game Expenses'!I10)","v":834800},{"$f":"SUM('Game Expenses'!K10)","v":891700},{"$f":"SUM('Game Expenses'!M10)","v":954800}]
["Medical Expenses",{"$f":"SUM('Medical Expenses'!B9)","v":480000},{"$f":"SUM('Medical Expenses'!C9)","v":552000},{"$f":"SUM('Medical Expenses'!D9)","v":450000},{"$f":"SUM('Medical Expenses'!E9)","v":599700},{"$f":"SUM('Medical Expenses'!G9)","v":651800},{"$f":"SUM('Medical Expenses'!I9)","v":708700},{"$f":"SUM('Medical Expenses'!K9)","v":770900},{"$f":"SUM('Medical Expenses'!M9)","v":838900}]
["Guarantees",{"$f":"SUM('Guarantees-Exp'!B14)","v":320000},{"$f":"SUM('Guarantees-Exp'!C14)","v":360000},{"$f":"SUM('Guarantees-Exp'!D14)","v":340000},{"$f":"SUM('Guarantees-Exp'!E14)","v":378000},{"$f":"SUM('Guarantees-Exp'!G14)","v":396900},{"$f":"SUM('Guarantees-Exp'!I14)","v":416800},{"$f":"SUM('Guarantees-Exp'!K14)","v":425200},{"$f":"SUM('Guarantees-Exp'!M14)","v":433800}]
["Direct Facilitites",{"$f":"SUM('Direct Facilities'!B13)","v":812800},{"$f":"SUM('Direct Facilities'!C13)","v":895000},{"$f":"SUM('Direct Facilities'!D13)","v":721000},{"$f":"SUM('Direct Facilities'!E13)","v":1069800},{"$f":"SUM('Direct Facilities'!G13)","v":1102000},{"$f":"SUM('Direct Facilities'!I13)","v":1135100},{"$f":"SUM('Direct Facilities'!K13)","v":1169100},{"$f":"SUM('Direct Facilities'!M13)","v":1204100}]
["Fundraising",{"$f":"SUM(Fundraising!B12)","v":158500},{"$f":"SUM(Fundraising!C12)","v":205000},{"$f":"SUM(Fundraising!D12)","v":153000},{"$f":"SUM(Fundraising!E12)","v":217800},{"$f":"SUM(Fundraising!G12)","v":231500},{"$f":"SUM(Fundraising!I12)","v":246200},{"$f":"SUM(Fundraising!K12)","v":261800},{"$f":"SUM(Fundraising!M12)","v":278500}]
["Sports Camps",{"$f":"SUM('Sports Camp Exp.'!B42)","v":196200},{"$f":"SUM('Sports Camp Exp.'!C42)","v":249700},{"$f":"SUM('Sports Camp Exp.'!D42)","v":191000},{"$f":"SUM('Sports Camp Exp.'!E42)","v":262300},{"$f":"SUM('Sports Camp Exp.'!G42)","v":275400},{"$f":"SUM('Sports Camp Exp.'!I42)","v":289100},{"$f":"SUM('Sports Camp Exp.'!K42)","v":303600},{"$f":"SUM('Sports Camp Exp.'!M42)","v":318900}]
["Spirit Groups",{"$f":"SUM('Spirit Groups'!B12)","v":18300},{"$f":"SUM('Spirit Groups'!C12)","v":22000},{"$f":"SUM('Spirit Groups'!D12)","v":16300},{"$f":"SUM('Spirit Groups'!E12)","v":23200},{"$f":"SUM('Spirit Groups'!G12)","v":24400},{"$f":"SUM('Spirit Groups'!I12)","v":25700},{"$f":"SUM('Spirit Groups'!K12)","v":27000},{"$f":"SUM('Spirit Groups'!M12)","v":28400}]
["Membership Dues",{"$f":"SUM('Memberships & Dues'!B40)","v":120650},{"$f":"SUM('Memberships & Dues'!C40)","v":158050},{"$f":"SUM('Memberships & Dues'!D40)","v":149100},{"$f":"SUM('Memberships & Dues'!E40)","v":164500},{"$f":"SUM('Memberships & Dues'!G40)","v":171300},{"$f":"SUM('Memberships & Dues'!I40)","v":178400},{"$f":"SUM('Memberships & Dues'!K40)","v":185900},{"$f":"SUM('Memberships & Dues'!M40)","v":193800}]
["Other Expenses",{"$f":"SUM('Other Expenses'!B11)","v":0},{"$f":"SUM('Other Expenses'!C11)","v":0},{"$f":"SUM('Other Expenses'!D11)","v":0},{"$f":"SUM('Other Expenses'!E11)","v":0},{"$f":"SUM('Other Expenses'!G11)","v":0},{"$f":"SUM('Other Expenses'!I11)","v":0},{"$f":"SUM('Other Expenses'!K11)","v":0},{"$f":"SUM('Other Expenses'!M11)","v":0}]
["Total Cash Only Expenses",{"$f":"SUM(B22:B37)","v":18222790},20331235,17901660,21482400,22468300,23506100,24586700,25725800]
[]
["Cash Revenues-Cash Expenses",{"$f":"B19-B38","v":120760},148115,500440,-349700,-606200,-564200,-478100,-372700]

{"sheet":"Summary #3","index":2,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,8]]}
[null,"In-Kind Gifts (Revenues and Expenses)"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Year 2","Year 3","Year 4","Year 5"]
[]
["In-Kind Revenues"]
["Contributions",{"$f":"SUM(Contributions!B36)","v":3200},{"$f":"SUM(Contributions!C36)","v":3500},{"$f":"SUM(Contributions!D36)","v":2800},{"$f":"SUM(Contributions!E36)","v":3700},{"$f":"SUM(Contributions!G36)","v":3700},{"$f":"SUM(Contributions!I36)","v":3700},{"$f":"SUM(Contributions!K36)","v":3700},{"$f":"SUM(Contributions!M36)","v":3700}]
["Royalties",{"$f":"SUM(Royalties!B10)","v":82000},{"$f":"SUM(Royalties!C10)","v":91000},{"$f":"SUM(Royalties!D10)","v":80000},{"$f":"SUM(Royalties!E10)","v":95600},{"$f":"SUM(Royalties!G10)","v":100400},{"$f":"SUM(Royalties!I10)","v":105400},{"$f":"SUM(Royalties!K10)","v":110700},{"$f":"SUM(Royalties!M10)","v":116200}]
[]
["Total In-Kind Revenues",{"$f":"SUM(B6:B8)","v":85200},94500,82800,99300,104100,109100,114400,119900]
[]
["In-Kind Expenses"]
["Recruiting",{"$f":"SUM(Recruiting!B39)","v":1400},{"$f":"SUM(Recruiting!C39)","v":1700},{"$f":"SUM(Recruiting!D39)","v":1400},{"$f":"SUM(Recruiting!E39)","v":1700},{"$f":"SUM(Recruiting!G39)","v":1700},{"$f":"SUM(Recruiting!I39)","v":1700},{"$f":"SUM(Recruiting!K39)","v":1700},{"$f":"SUM(Recruiting!M39)","v":1700}]
["Team Travel",{"$f":"SUM('Team Travel'!B41)","v":7300},{"$f":"SUM('Team Travel'!C41)","v":7550},{"$f":"SUM('Team Travel'!D41)","v":6900},{"$f":"SUM('Team Travel'!E41)","v":7900},{"$f":"SUM('Team Travel'!G41)","v":8300},{"$f":"SUM('Team Travel'!I41)","v":8700},{"$f":"SUM('Team Travel'!K41)","v":9100},{"$f":"SUM('Team Travel'!M41)","v":9600}]
["Equipment",{"$f":"SUM(Equipment!B41)","v":73000},{"$f":"SUM(Equipment!C41)","v":80000},{"$f":"SUM(Equipment!D41)","v":73000},{"$f":"SUM(Equipment!E41)","v":82400},{"$f":"SUM(Equipment!G41)","v":84800},{"$f":"SUM(Equipment!I41)","v":87400},{"$f":"SUM(Equipment!K41)","v":90000},{"$f":"SUM(Equipment!M41)","v":92700}]
[]
["Total In-Kind Expenses",{"$f":"SUM(B12:B15)","v":81700},89250,81300,92000,94800,97800,100800,104000]

{"sheet":"Summary #4","index":3,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,1,0,8]]}
[null,"Sports Camps-Revenues and Expenses Summary"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Year 2","Year 3","Year 4","Year 5"]
[]
["Revenues",{"$f":"SUM('Sports Camps'!B40)","v":239450},{"$f":"SUM('Sports Camps'!C40)","v":269700},{"$f":"SUM('Sports Camps'!D40)","v":238000},{"$f":"SUM('Sports Camps'!E40)","v":283100},{"$f":"SUM('Sports Camps'!G40)","v":297400},{"$f":"SUM('Sports Camps'!I40)","v":312300},{"$f":"SUM('Sports Camps'!K40)","v":328000},{"$f":"SUM('Sports Camps'!M40)","v":360600}]
["Expenses",{"$f":"SUM('Sports Camp Exp.'!B42)","v":196200},{"$f":"SUM('Sports Camp Exp.'!C42)","v":249700},{"$f":"SUM('Sports Camp Exp.'!D42)","v":191000},{"$f":"SUM('Sports Camp Exp.'!E42)","v":262300},{"$f":"SUM('Sports Camp Exp.'!G42)","v":275400},{"$f":"SUM('Sports Camp Exp.'!I42)","v":289100},{"$f":"SUM('Sports Camp Exp.'!K42)","v":303600},{"$f":"SUM('Sports Camp Exp.'!M42)","v":318900}]
[]
["Revenues-Expenses",{"$f":"B5-B6","v":43250},20000,47000,20800,22000,23200,24400,41700]

{"sheet":"Ticket Sales","index":4,"n_rows":39,"n_cols":14,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Ticket Sales Revenue-All Sports"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
["Men's Sports"]
["Basketball*",{"$f":"SUM('Ticket Plans'!B19)","v":128500},{"$f":"SUM('Ticket Plans'!C19)","v":147000},{"$f":"SUM('Ticket Plans'!D19)","v":127000},{"$f":"SUM('Ticket Plans'!E19)","v":159100},null,{"$f":"SUM('Ticket Plans'!G19)","v":173200},null,{"$f":"SUM('Ticket Plans'!I19)","v":180300},null,{"$f":"SUM('Ticket Plans'!K19)","v":187800},null,{"$f":"SUM('Ticket Plans'!M19)","v":195600}]
["Baseball",40200,41100,39000,45500,0.1,{"$f":"ROUND(E6+(E6*H6),-2)","v":47800},0.05,{"$f":"ROUND(G6+(G6*J6),-2)","v":50200},0.05,{"$f":"ROUND(I6+(I6*L6),-2)","v":52700},0.05,{"$f":"ROUND(K6+(K6*N6),-2)","v":55300},0.05]
["Football*",{"$f":"SUM('Ticket Plans'!B11)","v":11348500},{"$f":"SUM('Ticket Plans'!C11)","v":13050000},{"$f":"SUM('Ticket Plans'!D11)","v":11538000},{"$f":"SUM('Ticket Plans'!E11)","v":13291700},null,{"$f":"SUM('Ticket Plans'!G11)","v":13557500},null,{"$f":"SUM('Ticket Plans'!I11)","v":14172400},null,{"$f":"SUM('Ticket Plans'!K11)","v":14874000},null,{"$f":"SUM('Ticket Plans'!M11)","v":15535900}]
["Gymnastics",0,0,0,{"$f":"ROUND(C8+(C8*F8),-2)","v":0},0.01,0,0.01,0,0.01,0,0.01,0,0.01]
["Golf",2000,3600,3500,3700,0.02,3800,0.02,3900,0.02,4000,0.02,4100,0.02]
["Ice Hockey",0,0,0,0,0.02,0,0.02,0,0.02,0,0.02,0,0.02]
["Lacrosse",0,0,0,0,0.02,0,0.02,0,0.02,0,0.02,0,0.02]
["Soccer",2500,3100,2900,3200,0.02,3300,0.02,3400,0.02,3500,0.02,3600,0.02]
["Swimming",33100,34800,35000,35500,0.02,37300,0.05,38000,0.02,39900,0.05,41900,0.05]
["Tennis",2000,3000,2500,3100,0.02,3200,0.02,3300,0.02,3400,0.02,3500,0.02]
["Track and Field",2000,3000,2400,3100,0.02,3200,0.02,3300,0.02,3400,0.02,3500,0.02]
["Volleyball",0,0,0,0,0.02,0,0.02,0,0.02,0,0.02,0,0.02]
["Wrestling",0,0,0,0,0.02,0,0.02,0,0.02,0,0.02,0,0.02]
["Other",0,0,0,0,0.02,{"$f":"ROUND(E18+(E18*H18),-2)","v":0},0.02,{"$f":"ROUND(G18+(G18*J18),-2)","v":0},0.02,{"$f":"ROUND(I18+(I18*L18),-2)","v":0},0.02,{"$f":"ROUND(K18+(K18*N18),-2)","v":0},0.02]
[]
["Women's Sports"]
["Basketball*",{"$f":"SUM('Ticket Plans'!B27)","v":7800},{"$f":"SUM('Ticket Plans'!C27)","v":7800},{"$f":"SUM('Ticket Plans'!D27)","v":6500},{"$f":"SUM('Ticket Plans'!E27)","v":8200},null,{"$f":"SUM('Ticket Plans'!G27)","v":8300},null,{"$f":"SUM('Ticket Plans'!I27)","v":8400},null,{"$f":"SUM('Ticket Plans'!K27)","v":8500},null,{"$f":"SUM('Ticket Plans'!M27)","v":8600}]
["Field Hockey",0,0,0,{"$f":"ROUND(C22+(C22*F22),-2)","v":0},0.02,0,0.02,0,0.02,0,0.02,0,0.02]
["Golf",0,0,0,0,0.02,0,0.02,0,0.02,0,0.02,0,0.02]
["Gymnastics",0,0,0,0,0.02,0,0.02,0,0.02,0,0.02,0,0.02]
["Ice Hockey",0,0,0,0,0.02,0,0.02,0,0.02,0,0.02,0,0.02]
["Lacrosse",0,0,0,0,0.02,0,0.02,0,0.02,0,0.02,0,0.02]
["Soccer",2000,2200,2000,2200,0.02,2200,0.02,2200,0.02,2200,0.02,2200,0.02]
["Softball",1800,2300,2000,2300,0.02,2300,0.02,2300,0.02,2300,0.02,2300,0.02]
["Swimming",29200,30500,31000,31100,0.02,32700,0.05,33400,0.02,35100,0.05,36900,0.05]
["Tennis",1800,2000,1500,2000,0.02,2000,0.02,2000,0.02,2000,0.02,2000,0.02]
["Track and Field",1600,1800,1500,1800,0.02,1800,0.02,1800,0.02,1800,0.02,1800,0.02]
["Volleyball",850,950,800,1000,0.02,1000,0.02,1000,0.02,1000,0.02,1000,0.02]
["Other"]
[]
["Postage and Handling",23000,25000,19000,{"$f":"ROUND(C35+(C35*F35),-2)","v":25500},0.02,{"$f":"ROUND(E35+(E35*H35),-2)","v":26000},0.02,26500,0.02,27000,0.02,27500,0.02]
["Total Ticket Sale Revenue",{"$f":"SUM(B5:B35)","v":11626850},13358150,{"$f":"SUM(D5:D35)","v":11814600},13619000,null,13905600,null,14532400,null,15248600,null,15925700]
[]
[]
["*Prefills from Ticket Plans Sheet"]

{"sheet":"Ticket Plans","index":5,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Ticket Plans"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
[]
["Football"]
["Regular Season",9000000,9890000,9000000,{"$f":"ROUND(C6+(C6*F6),-2)","v":9692200},-0.02,{"$f":"ROUND(E6+(E6*H6),-2)","v":9886000},0.02,{"$f":"ROUND(G6+(G6*J6),-2)","v":10380300},0.05,{"$f":"ROUND(I6+(I6*L6),-2)","v":10899300},0.05,{"$f":"ROUND(K6+(K6*N6),-2)","v":11444300},0.05]
["Mini-Plans",2200000,3000000,2400000,{"$f":"ROUND(C7+(C7*F7),-2)","v":3420000},0.14000000000000001,{"$f":"ROUND(E7+(E7*H7),-2)","v":3488400},0.02,{"$f":"ROUND(G7+(G7*J7),-2)","v":3558200},0.02,{"$f":"ROUND(I7+(I7*L7),-2)","v":3736100},0.05,{"$f":"ROUND(K7+(K7*N7),-2)","v":3848200},0.03]
["Discounted Faculty/Staff",8500,10000,8000,{"$f":"ROUND(C8+(C8*F8),-2)","v":14500},0.45,{"$f":"ROUND(E8+(E8*H8),-2)","v":14800},0.02,{"$f":"ROUND(G8+(G8*J8),-2)","v":15100},0.02,{"$f":"ROUND(I8+(I8*L8),-2)","v":15400},0.02,{"$f":"ROUND(K8+(K8*N8),-2)","v":15700},0.02]
["Student ",140000,150000,130000,{"$f":"ROUND(C9+(C9*F9),-2)","v":165000},0.1,{"$f":"ROUND(E9+(E9*H9),-2)","v":168300},0.02,{"$f":"ROUND(G9+(G9*J9),-2)","v":218800},0.3,{"$f":"ROUND(I9+(I9*L9),-2)","v":223200},0.02,{"$f":"ROUND(K9+(K9*N9),-2)","v":227700},0.02]
["Other",0,0,0,{"$f":"ROUND(C10+(C10*F10),-2)","v":0},0,{"$f":"ROUND(E10+(E10*H10),-2)","v":0},0.02,{"$f":"ROUND(G10+(G10*J10),-2)","v":0},0.02,{"$f":"ROUND(I10+(I10*L10),-2)","v":0},0.02,{"$f":"ROUND(K10+(K10*N10),-2)","v":0},0.02]
["Total Football Ticket Sales",{"$f":"SUM(B6:B10)","v":11348500},13050000,{"$f":"SUM(D6:D10)","v":11538000},13291700,null,13557500,null,14172400,null,14874000,null,15535900]
[]
["Men's Basketball"]
["Regular Season",90000,100000,90000,{"$f":"ROUND(C14+(C14*F14),-2)","v":110000},0.1,{"$f":"ROUND(E14+(E14*H14),-2)","v":123200},0.12,{"$f":"ROUND(G14+(G14*J14),-2)","v":129400},0.05,{"$f":"ROUND(I14+(I14*L14),-2)","v":135900},0.05,{"$f":"ROUND(K14+(K14*N14),-2)","v":142700},0.05]
["Mini-Plans",25000,30000,28000,{"$f":"ROUND(C15+(C15*F15),-2)","v":31500},0.05,{"$f":"ROUND(E15+(E15*H15),-2)","v":32100},0.02,{"$f":"ROUND(G15+(G15*J15),-2)","v":32700},0.02,{"$f":"ROUND(I15+(I15*L15),-2)","v":33400},0.02,{"$f":"ROUND(K15+(K15*N15),-2)","v":34100},0.02]
["Discounted Faculty/Staff",4500,6000,3000,{"$f":"ROUND(C16+(C16*F16),-2)","v":6400},0.06,{"$f":"ROUND(E16+(E16*H16),-2)","v":6500},0.02,{"$f":"ROUND(G16+(G16*J16),-2)","v":6600},0.02,{"$f":"ROUND(I16+(I16*L16),-2)","v":6700},0.02,{"$f":"ROUND(K16+(K16*N16),-2)","v":6800},0.02]
["Student ",9000,11000,6000,{"$f":"ROUND(C17+(C17*F17),-2)","v":11200},0.02,{"$f":"ROUND(E17+(E17*H17),-2)","v":11400},0.02,{"$f":"ROUND(G17+(G17*J17),-2)","v":11600},0.02,{"$f":"ROUND(I17+(I17*L17),-2)","v":11800},0.02,{"$f":"ROUND(K17+(K17*N17),-2)","v":12000},0.02]
["Other",0,0,0,{"$f":"ROUND(C18+(C18*F18),-2)","v":0},0.02,{"$f":"ROUND(E18+(E18*H18),-2)","v":0},0.02,{"$f":"ROUND(G18+(G18*J18),-2)","v":0},0.02,{"$f":"ROUND(I18+(I18*L18),-2)","v":0},0.02,{"$f":"ROUND(K18+(K18*N18),-2)","v":0},0.02]
["Total Men's Basketball Ticket Sales",{"$f":"SUM(B14:B18)","v":128500},147000,127000,159100,null,173200,null,180300,null,187800,null,195600]
[]
["Women's Basketball"]
["Regular Season",4000,4000,3600,{"$f":"ROUND(C22+(C22*F22),-2)","v":4200},0.05,{"$f":"ROUND(E22+(E22*H22),-2)","v":4300},0.02,{"$f":"ROUND(G22+(G22*J22),-2)","v":4400},0.02,{"$f":"ROUND(I22+(I22*L22),-2)","v":4500},0.02,{"$f":"ROUND(K22+(K22*N22),-2)","v":4600},0.02]
["Mini-Plans",1200,1200,1000,{"$f":"ROUND(C23+(C23*F23),-2)","v":1300},0.05,{"$f":"ROUND(E23+(E23*H23),-2)","v":1300},0.02,{"$f":"ROUND(G23+(G23*J23),-2)","v":1300},0.02,{"$f":"ROUND(I23+(I23*L23),-2)","v":1300},0.02,{"$f":"ROUND(K23+(K23*N23),-2)","v":1300},0.02]
["Discounted Faculty/Staff",600,600,400,{"$f":"ROUND(C24+(C24*F24),-2)","v":600},0.02,{"$f":"ROUND(E24+(E24*H24),-2)","v":600},0.02,{"$f":"ROUND(G24+(G24*J24),-2)","v":600},0.02,{"$f":"ROUND(I24+(I24*L24),-2)","v":600},0.02,{"$f":"ROUND(K24+(K24*N24),-2)","v":600},0.02]
["Student ",2000,2000,1500,{"$f":"ROUND(C25+(C25*F25),-2)","v":2100},0.03,{"$f":"ROUND(E25+(E25*H25),-2)","v":2100},0.02,{"$f":"ROUND(G25+(G25*J25),-2)","v":2100},0.02,{"$f":"ROUND(I25+(I25*L25),-2)","v":2100},0.02,{"$f":"ROUND(K25+(K25*N25),-2)","v":2100},0.02]
["Other",0,0,0,{"$f":"ROUND(C26+(C26*F26),-2)","v":0},0.02,{"$f":"ROUND(E26+(E26*H26),-2)","v":0},0.02,{"$f":"ROUND(G26+(G26*J26),-2)","v":0},0.02,{"$f":"ROUND(I26+(I26*L26),-2)","v":0},0.02,{"$f":"ROUND(K26+(K26*N26),-2)","v":0},0.02]
["Total Women's Basketball Ticket Sales",{"$f":"SUM(B22:B26)","v":7800},7800,6500,8200,null,8300,null,8400,null,8500,null,8600]
[]
["Other Sport"]
["Regular Season",0,0,0,{"$f":"ROUND(C30+(C30*F30),-2)","v":0},null,{"$f":"ROUND(E30+(E30*H30),-2)","v":0},null,{"$f":"ROUND(G30+(G30*J30),-2)","v":0},null,{"$f":"ROUND(I30+(I30*L30),-2)","v":0},null,{"$f":"ROUND(K30+(K30*N30),-2)","v":0}]
["Mini-Plans",0,0,0,{"$f":"ROUND(C31+(C31*F31),-2)","v":0},null,{"$f":"ROUND(E31+(E31*H31),-2)","v":0},null,{"$f":"ROUND(G31+(G31*J31),-2)","v":0},null,{"$f":"ROUND(I31+(I31*L31),-2)","v":0},null,{"$f":"ROUND(K31+(K31*N31),-2)","v":0}]
["Discounted Faculty/Staff",0,0,0,{"$f":"ROUND(C32+(C32*F32),-2)","v":0},null,{"$f":"ROUND(E32+(E32*H32),-2)","v":0},null,{"$f":"ROUND(G32+(G32*J32),-2)","v":0},null,{"$f":"ROUND(I32+(I32*L32),-2)","v":0},null,{"$f":"ROUND(K32+(K32*N32),-2)","v":0}]
["Student ",0,0,0,{"$f":"ROUND(C33+(C33*F33),-2)","v":0},null,{"$f":"ROUND(E33+(E33*H33),-2)","v":0},null,{"$f":"ROUND(G33+(G33*J33),-2)","v":0},null,{"$f":"ROUND(I33+(I33*L33),-2)","v":0},null,{"$f":"ROUND(K33+(K33*N33),-2)","v":0}]
["Other",0,0,0,{"$f":"ROUND(C34+(C34*F34),-2)","v":0},null,{"$f":"ROUND(E34+(E34*H34),-2)","v":0},null,{"$f":"ROUND(G34+(G34*J34),-2)","v":0},null,{"$f":"ROUND(I34+(I34*L34),-2)","v":0},null,{"$f":"ROUND(K34+(K34*N34),-2)","v":0}]
["Total Other Ticket Sales",{"$f":"SUM(B30:B34)","v":0},0,0,0,null,0,null,0,null,0,null,0]
[]
["Total Ticket Plans",{"$f":"B11+B19+B27","v":11484800},13204800,11671500,13459000,null,13739000,null,14361100,null,15070300,null,15740100]
[]
[]
["*Prefills to Ticket Sales Sheet"]

{"sheet":"Guarantees-Rev","index":6,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Guarantees (Revenues)"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
[]
["Football",82000,250000,220000,{"$f":"ROUND(C5+(C5*F5),-2)","v":265000},0.06,{"$f":"ROUND(E5+(E5*H5),-2)","v":278300},0.05,{"$f":"ROUND(G5+(G5*J5),-2)","v":292200},0.05,{"$f":"ROUND(I5+(I5*L5),-2)","v":306800},0.05,{"$f":"ROUND(K5+(K5*N5),-2)","v":331300},0.08]
["Men's Basketball",120500,150000,110000,{"$f":"ROUND(C6+(C6*F6),-2)","v":157500},0.05,{"$f":"ROUND(E6+(E6*H6),-2)","v":165400},0.05,173700,0.05,182400,0.05,197000,0.08]
["Women's Basketball",5500,10000,8000,10500,0.05,11000,0.05,11600,0.05,12200,0.05,13200,0.08]
["Men's Baseball",10000,10500,9000,26300,1.5,27600,0.05,29000,0.05,30500,0.05,32900,0.08]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
[]
["Total Guarantees-Revenues",{"$f":"SUM(B5:B12)","v":218000},{"$f":"SUM(C5:C12)","v":420500},{"$f":"SUM(D5:D12)","v":347000},{"$f":"SUM(E5:E12)","v":459300},null,{"$f":"SUM(G5:G12)","v":482300},null,{"$f":"SUM(I5:I12)","v":506500},null,{"$f":"SUM(K5:K12)","v":531900},null,{"$f":"SUM(M5:M12)","v":574400}]

{"sheet":"Contributions","index":7,"n_rows":41,"n_cols":14,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Contributions (Individuals, Corporations, Associations, Foundations, Clubs, Other)"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
[]
["Men's Sports"]
["Basketball",90000,92000,85000,{"$f":"ROUND(C6+(C6*F6),-2)","v":87400},-0.05,{"$f":"ROUND(E6+(E6*H6),-2)","v":96100},0.1,{"$f":"ROUND(G6+(G6*J6),-2)","v":100900},0.05,{"$f":"ROUND(I6+(I6*L6),-2)","v":111000},0.1,{"$f":"ROUND(K6+(K6*N6),-2)","v":122100},0.1]
["Baseball",46000,49000,40000,46600,-0.05,51300,0.1,53900,0.05,59300,0.1,65200,0.1]
["Football",205000,210000,215000,199500,-0.05,219500,0.1,230500,0.05,246600,7.0000000000000007E-2,263900,7.0000000000000007E-2]
["Gymnastics",0,0,0,0,null,0,null,0,null,0,null,0]
["Golf",0,0,0,0,null,0,null,0,null,0,null,0]
["Ice Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Lacrosse",0,0,0,0,null,0,null,0,null,0,null,0]
["Soccer",0,0,0,0,null,0,null,0,null,0,null,0]
["Swimming",132000,133000,130000,146300,0.1,146300,null,146300,null,146300,null,146300]
["Tennis",0,0,0,0,null,0,null,0,null,0,null,0]
["Track and Field",0,0,0,0,null,0,null,0,null,0,null,0]
["Volleyball",0,0,0,0,null,0,null,0,null,0,null,0]
["Wrestling",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
[]
["Women's Sports"]
["Basketball",16000,20000,19000,{"$f":"ROUND(C22+(C22*F22),-2)","v":20000},null,20000,null,20000,null,20000,null,20000]
["Field Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Golf",0,0,0,0,null,0,null,0,null,0,null,0]
["Gymnastics",0,0,0,0,null,0,null,0,null,0,null,0]
["Ice Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Lacrosse",0,0,0,0,null,0,null,0,null,0,null,0]
["Soccer",0,0,0,0,null,0,null,0,null,0,null,0]
["Softball",0,0,0,0,null,0,null,0,null,0,null,0]
["Swimming",71000,72000,65000,72000,null,72000,null,72000,null,72000,null,72000]
["Tennis",0,0,0,0,null,0,null,0,null,0,null,0]
["Track and Field",0,0,0,0,null,0,null,0,null,0,null,0]
["Volleyball",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
[]
["Men's and Women's In-Kind Gifts ",3200,3500,2800,3700,0.05,3700,null,3700,null,3700,null,3700]
[]
["Total Contributions",{"$f":"SUM(B6:B37)","v":563200},579500,556800,575500,null,608900,null,627300,null,658900,null,693200]
[]
["Total Contributions less In-Kind*",{"$f":"B38-B36","v":560000},576000,554000,571800,null,605200,null,623600,null,655200,null,689500]
["*Prefills to Summary #2"]

{"sheet":"3rd Party Comp","index":8,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"3rd Party Compensation "]
[null,null,"Current Year","Current Year "]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
["Men's Sports"]
["Basketball",10000,10000,80000,{"$f":"ROUND(C5+(C5*F5),-2)","v":11000},0.1,{"$f":"ROUND(E5+(E5*H5),-2)","v":11000},null,{"$f":"ROUND(G5+(G5*J5),-2)","v":11000},null,{"$f":"ROUND(I5+(I5*L5),-2)","v":11000},null,{"$f":"ROUND(K5+(K5*N5),-2)","v":11000}]
["Baseball",0,0,0,{"$f":"ROUND(C6+(C6*F6),-2)","v":0},null,0,null,0,null,0,null,0]
["Football",29000,28000,20000,28000,null,28000,null,28000,null,28000,null,28000]
["Gymnastics",0,0,0,0,null,0,null,0,null,0,null,0]
["Golf",0,0,0,0,null,0,null,0,null,0,null,0]
["Ice Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Lacrosse",0,0,0,0,null,0,null,0,null,0,null,0]
["Soccer",0,0,0,0,null,0,null,0,null,0,null,0]
["Swimming",0,0,0,0,null,0,null,0,null,0,null,0]
["Tennis",0,0,0,0,null,0,null,0,null,0,null,0]
["Track and Field",0,0,0,0,null,0,null,0,null,0,null,0]
["Volleyball",0,0,0,0,null,0,null,0,null,0,null,0]
["Wrestling",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
[]
["Women's Sports"]
["Basketball",0,0,0,{"$f":"ROUND(C21+(C21*F21),-2)","v":0},null,0,null,0,null,0,null,0]
["Field Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Golf",0,0,0,0,null,0,null,0,null,0,null,0]
["Gymnastics",0,0,0,0,null,0,null,0,null,0,null,0]
["Ice Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Lacrosse",0,0,0,0,null,0,null,0,null,0,null,0]
["Soccer",0,0,0,0,null,0,null,0,null,0,null,0]
["Softball",0,0,0,0,null,0,null,0,null,0,null,0]
["Swimming",0,0,0,0,null,0,null,0,null,0,null,0]
["Tennis",0,0,0,0,null,0,null,0,null,0,null,0]
["Track and Field",0,0,0,0,null,0,null,0,null,0,null,0]
["Volleyball",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
[]
["Total 3rd Party Compensation",{"$f":"SUM(B5:B34)","v":39000},38000,{"$f":"SUM(D5:D34)","v":100000},39000,null,39000,null,39000,null,39000,null,39000]

{"sheet":"NCAA-Conference","index":9,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"NCAA/Conference Distributions"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
[]
["Basketball Television",7000,6000,4000,{"$f":"ROUND(C5+(C5*F5),-2)","v":6100},0.02,{"$f":"ROUND(E5+(E5*H5),-2)","v":6200},0.02,{"$f":"ROUND(G5+(G5*J5),-2)","v":6300},0.02,{"$f":"ROUND(I5+(I5*L5),-2)","v":6400},0.02,{"$f":"ROUND(K5+(K5*N5),-2)","v":6500},0.02]
["Basketball Revenue Sharing",7000,6000,4000,6100,0.02,6200,0.02,6300,0.02,6400,0.02,6500,0.02]
["NCAA Tournament",285000,299500,280000,314500,0.05,330200,0.05,346700,0.05,381400,0.1,419500,0.1]
["Football Television",0,0,0,0,null,0,null,0,null,0,null,0]
["Football Bowls",0,0,0,0,null,0,null,0,null,0,null,0]
["Additional NCAA Distribution",7000,6000,5000,6100,0.02,6200,0.02,6300,0.02,6400,0.02,6500,0.02]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
[]
[]
["Total Conference Revenue",{"$f":"SUM(B5:B13)","v":306000},317500,{"$f":"SUM(D5:D13)","v":293000},332800,null,348800,null,365600,null,400600,null,439000]

{"sheet":"Broadcast Rights","index":10,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Broadcast Rights"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
[]
["Internet/E-commerce",3000,5000,4000,{"$f":"ROUND(C5+(C5*F5),-2)","v":5500},0.1,{"$f":"ROUND(E5+(E5*H5),-2)","v":6100},0.1,{"$f":"ROUND(G5+(G5*J5),-2)","v":6700},0.1,{"$f":"ROUND(I5+(I5*L5),-2)","v":7400},0.1,{"$f":"ROUND(K5+(K5*N5),-2)","v":8100},0.1]
["Radio",22500,25000,20000,{"$f":"ROUND(C6+(C6*F6),-2)","v":26300},0.05,27600,0.05,29000,0.05,30500,0.05,32000,0.05]
["Television",4000,5000,4000,5200,0.03,5400,0.03,5600,0.03,5800,0.03,6000,0.03]
[]
[]
["Total Broadcast Rights",{"$f":"SUM(B5:B9)","v":29500},35000,{"$f":"SUM(D5:D9)","v":28000},37000,null,39100,null,41300,null,43700,null,46100]

{"sheet":"Event Sales","index":11,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Event Sales"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
[]
["Food concession",6500,7000,5000,{"$f":"ROUND(C5+(C5*F5),-2)","v":7000},null,{"$f":"ROUND(E5+(E5*H5),-2)","v":7000},null,{"$f":"ROUND(G5+(G5*J5),-2)","v":7000},null,{"$f":"ROUND(I5+(I5*L5),-2)","v":7000},null,{"$f":"ROUND(K5+(K5*N5),-2)","v":7000}]
["Game programs",750,800,500,{"$f":"ROUND(C6+(C6*F6),-2)","v":800},null,800,null,800,null,800,null,800]
["Novelties",1100,1200,1000,1200,null,1200,null,1200,null,1200,null,1200]
["Parking revenue",0,0,0,0,null,0,null,0,null,0,null,0]
[]
[]
["Total Event Sales",{"$f":"SUM(B5:B10)","v":8350},9000,{"$f":"SUM(D5:D10)","v":6500},9000,null,9000,null,9000,null,9000,null,9000]

{"sheet":"Royalties","index":12,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Royalties, Licensing, Advertisements and Sponsorships"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
[]
["Advertisements",130000,132000,120000,{"$f":"ROUND(C5+(C5*F5),-2)","v":138600},0.05,{"$f":"ROUND(E5+(E5*H5),-2)","v":152500},0.1,{"$f":"ROUND(G5+(G5*J5),-2)","v":167800},0.1,{"$f":"ROUND(I5+(I5*L5),-2)","v":184600},0.1,{"$f":"ROUND(K5+(K5*N5),-2)","v":203100},0.1]
["Corporate sponsorships",138000,140000,130000,{"$f":"ROUND(C6+(C6*F6),-2)","v":154000},0.1,169400,0.1,186300,0.1,204900,0.1,225400,0.1]
["Licensing",9200,10000,8000,10500,0.05,11000,0.05,11600,0.05,12200,0.05,12800,0.05]
["Royalties",11000,12000,12000,12600,0.05,13200,0.05,13900,0.05,14600,0.05,15300,0.05]
["Trademarks",7200,8000,6000,8400,0.05,8800,0.05,9200,0.05,9700,0.05,10200,0.05]
["In-Kind products/services",82000,91000,80000,95600,0.05,100400,0.05,105400,0.05,110700,0.05,116200,0.05]
[]
["Total Royalties",{"$f":"SUM(B5:B11)","v":377400},393000,{"$f":"SUM(D5:D11)","v":356000},419700,null,455300,null,494200,null,536700,null,583000]
[]
["Total Royalties less In-Kind*",{"$f":"B12-B10","v":295400},302000,276000,324100,null,354900,null,388800,null,426000,null,466800]
[]
["*fills to Summary #2"]

{"sheet":"Sports Camps","index":13,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Sports Camp Revenues"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
[]
["Men's-Boy's Sports"]
["Basketball",25000,25700,20000,{"$f":"ROUND(C6+(C6*F6),-2)","v":27000},0.05,{"$f":"ROUND(E6+(E6*H6),-2)","v":28400},0.05,{"$f":"ROUND(G6+(G6*J6),-2)","v":29800},0.05,{"$f":"ROUND(I6+(I6*L6),-2)","v":31300},0.05,{"$f":"ROUND(K6+(K6*N6),-2)","v":34400},0.1]
["Baseball",53800,54500,50000,{"$f":"ROUND(C7+(C7*F7),-2)","v":57200},0.05,60100,0.05,63100,0.05,66300,0.05,72900,0.1]
["Football",96500,97800,90000,102700,0.05,107800,0.05,113200,0.05,118900,0.05,130800,0.1]
["Gymnastics",0,0,0,0,null,0,null,0,null,0,null,0]
["Golf",0,0,0,0,null,0,null,0,null,0,null,0]
["Ice Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Lacrosse",0,0,0,0,null,0,null,0,null,0,null,0]
["Soccer",12400,12700,11000,13300,0.05,14000,0.05,14700,0.05,15400,0.05,16900,0.1]
["Swimming",9800,10000,9000,10500,0.05,11000,0.05,11600,0.05,12200,0.05,13400,0.1]
["Tennis",0,0,0,0,null,0,null,0,null,0,null,0]
["Track and Field",0,0,0,0,null,0,null,0,null,0,null,0]
["Volleyball",0,0,0,0,null,0,null,0,null,0,null,0]
["Wrestling",0,0,0,0,null,0,null,0,null,0,null,0]
["Strength",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
[]
["Women's-Girls Sports"]
["Basketball",250,25700,20000,{"$f":"ROUND(C23+(C23*F23),-2)","v":27000},0.05,28400,0.05,29800,0.05,31300,0.05,34400,0.1]
["Field Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Golf",0,0,0,0,null,0,null,0,null,0,null,0]
["Gymnastics",0,0,0,0,null,0,null,0,null,0,null,0]
["Ice Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Lacrosse",0,0,0,0,null,0,null,0,null,0,null,0]
["Soccer",12500,12700,11000,13300,0.05,14000,0.05,14700,0.05,15400,0.05,16900,0.1]
["Softball",19800,20600,18000,21600,0.05,22700,0.05,23800,0.05,25000,0.05,27500,0.1]
["Swimming",9400,10000,9000,10500,0.05,11000,0.05,11600,0.05,12200,0.05,13400,0.1]
["Tennis",0,0,0,0,null,0,null,0,null,0,null,0]
["Track and Field",0,0,0,0,null,0,null,0,null,0,null,0]
["Volleyball",0,0,0,0,null,0,null,0,null,0,null,0]
["Cheerleading",0,0,0,0,null,0,null,0,null,0,null,0]
["Dance",0,0,0,0,null,0,null,0,null,0,null,0]
["Strength",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
[]
["Total Sports Camp Revenues",{"$f":"SUM(B6:B39)","v":239450},269700,{"$f":"SUM(D6:D39)","v":238000},283100,null,297400,null,312300,null,328000,null,360600]

{"sheet":"Endowment&Investment","index":14,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Endowment and Investment Income"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
[]
["Endowment income",0,0,0,{"$f":"ROUND(C5+(C5*F5),-2)","v":0},null,{"$f":"ROUND(E5+(E5*H5),-2)","v":0},null,{"$f":"ROUND(G5+(G5*J5),-2)","v":0},null,{"$f":"ROUND(I5+(I5*L5),-2)","v":0},null,{"$f":"ROUND(K5+(K5*N5),-2)","v":0}]
["Investment income",0,0,0,{"$f":"ROUND(C6+(C6*F6),-2)","v":0},null,{"$f":"ROUND(E6+(E6*H6),-2)","v":0},null,{"$f":"ROUND(G6+(G6*J6),-2)","v":0},null,{"$f":"ROUND(I6+(I6*L6),-2)","v":0},null,{"$f":"ROUND(K6+(K6*N6),-2)","v":0}]
[]
[]
[]
["Total Endowment & Investment Income",{"$f":"SUM(B5:B9)","v":0},0,{"$f":"SUM(D5:D9)","v":0},0,null,0,null,0,null,0,null,0]

{"sheet":"Other Revenue","index":15,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Other"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
[]
["Other revenue",0,0,0,{"$f":"ROUND(C5+(C5*F5),-2)","v":0},null,{"$f":"ROUND(E5+(E5*H5),-2)","v":0},null,{"$f":"ROUND(G5+(G5*J5),-2)","v":0},null,{"$f":"ROUND(I5+(I5*L5),-2)","v":0},null,{"$f":"ROUND(K5+(K5*N5),-2)","v":0}]
["Other revenue",0,0,0,{"$f":"ROUND(C6+(C6*F6),-2)","v":0},null,0,null,0,null,0,null,0]
["Other revenue",0,0,0,0,null,0,null,0,null,0,null,0]
[]
[]
["Total Other Revenue",{"$f":"SUM(B5:B9)","v":0},0,{"$f":"SUM(D5:D9)","v":0},0,null,0,null,0,null,0,null,0]

{"sheet":"Student Fees","index":16,"n_rows":8,"n_cols":14,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Student Athletic Fees"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
[]
["Student Athletic Fees",3010000,3030500,2900000,{"$f":"ROUND(C5+(C5*F5),-2)","v":3227500},6.5000000000000002E-2,{"$f":"ROUND(E5+(E5*H5),-2)","v":3437300},6.5000000000000002E-2,{"$f":"ROUND(G5+(G5*J5),-2)","v":3660700},6.5000000000000002E-2,{"$f":"ROUND(I5+(I5*L5),-2)","v":3862000},5.5E-2,{"$f":"ROUND(K5+(K5*N5),-2)","v":4132300},7.0000000000000007E-2]
[]
[]
["Total Student Athletic Fees",{"$f":"SUM(B5:B7)","v":3010000},3030500,{"$f":"SUM(D5:D7)","v":2900000},3227500,null,3437300,null,3660700,null,3862000,null,4132300]

{"sheet":"State-Government Support","index":17,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"State/Government Support"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
[]
["Federal level",0,0,0,{"$f":"ROUND(C5+(C5*F5),-2)","v":0},null,{"$f":"ROUND(E5+(E5*H5),-2)","v":0},null,{"$f":"ROUND(G5+(G5*J5),-2)","v":0},null,{"$f":"ROUND(I5+(I5*L5),-2)","v":0},null,{"$f":"ROUND(K5+(K5*N5),-2)","v":0}]
["Municipal level",0,0,0,{"$f":"ROUND(C6+(C6*F6),-2)","v":0},null,0,null,0,null,0,null,0]
["State level",0,0,0,0,null,0,null,0,null,0,null,0]
[]
[]
["Total State/Government Support",{"$f":"SUM(B5:B9)","v":0},0,{"$f":"SUM(D5:D9)","v":0},0,null,0,null,0,null,0,null,0]

{"sheet":"General Fund","index":18,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"General Fund (Institutional) Support"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
[]
["General Institutional Support",0,0,0,{"$f":"ROUND(C5+(C5*F5),-2)","v":0},null,{"$f":"ROUND(E5+(E5*H5),-2)","v":0},null,{"$f":"ROUND(G5+(G5*J5),-2)","v":0},null,{"$f":"ROUND(I5+(I5*L5),-2)","v":0},null,{"$f":"ROUND(K5+(K5*N5),-2)","v":0}]
["Tuition",85000,92000,80000,{"$f":"ROUND(C6+(C6*F6),-2)","v":96600},0.05,101400,0.05,106500,0.05,111800,0.05,117400,0.05]
["Tuition transfers",1900000,2000000,1800000,2100000,0.05,2205000,0.05,2315300,0.05,2407900,0.04,2504200,0.04]
["Tuition waivers",65000,69000,65000,72500,0.05,76100,0.05,79900,0.05,83900,0.05,88100,0.05]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
[]
[]
["Total General Fund(Institutional) Support",{"$f":"SUM(B5:B11)","v":2050000},2161000,{"$f":"SUM(D5:D11)","v":1945000},2269100,null,2382500,null,2501700,null,2603600,null,2709700]

{"sheet":"Indirect Inst. Support","index":19,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Indirect Institutional Support"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
[]
["Administrative Costs",0,0,0,{"$f":"ROUND(C5+(C5*F5),-2)","v":0},null,{"$f":"ROUND(E5+(E5*H5),-2)","v":0},null,{"$f":"ROUND(G5+(G5*J5),-2)","v":0},null,{"$f":"ROUND(I5+(I5*L5),-2)","v":0},null,{"$f":"ROUND(K5+(K5*N5),-2)","v":0}]
["Debt Service",80000,80000,70000,{"$f":"ROUND(C6+(C6*F6),-2)","v":80800},0.01,81600,0.01,85700,0.05,90000,0.05,94500,0.05]
["Depreciation",2000,2000,1500,2100,0.03,2200,0.03,2300,0.03,2400,0.03,2500,0.03]
["Facilities & Maintenance",3100,3400,3000,3500,0.03,3600,0.02,3700,0.02,3800,0.02,3900,0.02]
["Grounds & Field Maintenance",10000,10000,8000,10000,null,10000,null,10000,null,10000,null,10000]
["Risk Management",0,0,0,0,null,0,null,0,null,0,null,0]
["Security",10000,10000,7000,10000,null,10000,null,10000,null,10000,null,10000]
["Utilities",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
[]
["Total Indirect Facilities & Administrative Support",{"$f":"SUM(B5:B14)","v":105100},105400,{"$f":"SUM(D5:D14)","v":89500},106400,null,107400,null,111700,null,116200,null,120900]

{"sheet":"Athletic Aid","index":20,"n_rows":47,"n_cols":14,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Athletic Student Aid"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
[]
["Men's Sports"]
["Basketball",305000,268000,280000,{"$f":"ROUND(C6+(C6*F6),-2)","v":273400},0.02,{"$f":"ROUND(E6+(E6*H6),-2)","v":287100},0.05,{"$f":"ROUND(G6+(G6*J6),-2)","v":301500},0.05,{"$f":"ROUND(I6+(I6*L6),-2)","v":316600},0.05,{"$f":"ROUND(K6+(K6*N6),-2)","v":332400},0.05]
["Baseball",0,0,0,{"$f":"ROUND(C7+(C7*F7),-2)","v":0},null,0,null,0,null,0,null,0]
["Football",800000,860000,800000,881500,2.5000000000000001E-2,903500,2.5000000000000001E-2,926100,2.5000000000000001E-2,949300,2.5000000000000001E-2,973000,2.5000000000000001E-2]
["Gymnastics",0,0,0,0,null,0,null,0,null,0,null,0]
["Golf",55000,72000,60000,74200,0.03,75700,0.02,77200,0.02,78700,0.02,80300,0.02]
["Ice Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Lacrosse",0,0,0,0,null,0,null,0,null,0,null,0]
["Soccer",92000,168000,152000,173000,0.03,176500,0.02,180000,0.02,183600,0.02,187300,0.02]
["Swimming",202000,216000,203000,222500,0.03,227000,0.02,231500,0.02,236100,0.02,240800,0.02]
["Tennis",42000,96000,90000,98900,0.03,100900,0.02,102900,0.02,105000,0.02,107100,0.02]
["Track and Field",26000,168000,160000,173000,0.03,176500,0.02,180000,0.02,183600,0.02,187300,0.02]
["Volleyball",0,0,0,0,null,0,null,0,null,0,null,0]
["Wrestling",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Total Male Sports Student Aid",{"$f":"SUM(B6:B19)","v":1522000},1848000,1745000,1896500,null,1947200,null,1999200,null,2052900,null,2108200]
[]
["Women's Sports"]
["Basketball",200000,192000,180000,{"$f":"ROUND(C23+(C23*F23),-2)","v":195800},0.02,201700,0.03,207800,0.03,214000,0.03,220400,0.03]
["Field Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Golf",0,0,0,0,null,0,null,0,null,0,null,0]
["Gymnastics",0,0,0,0,null,0,null,0,null,0,null,0]
["Ice Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Lacrosse",0,0,0,0,null,0,null,0,null,0,null,0]
["Soccer",111000,192000,180000,195800,0.02,199700,0.02,203700,0.02,207800,0.02,212000,0.02]
["Softball",62000,168000,150000,171400,0.02,174800,0.02,178300,0.02,181900,0.02,185500,0.02]
["Swimming",203000,228000,200000,232600,0.02,237300,0.02,242000,0.02,246800,0.02,251700,0.02]
["Tennis",60000,108000,100000,110200,0.02,112400,0.02,114600,0.02,116900,0.02,119200,0.02]
["Track and Field",0,0,0,0,null,0,null,0,null,0,null,0]
["Volleyball",103000,192000,100000,195800,0.02,199700,0.02,203700,0.02,207800,0.02,212000,0.02]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Total Female Sports Student Aid",{"$f":"SUM(B23:B35)","v":739000},1080000,910000,1101600,null,1125600,null,1150100,null,1175200,null,1200800]
[]
["Other Aid"]
["Graduate Assistants",0,0,0,{"$f":"ROUND(C39+(C39*F39),-2)","v":0},null,0,null,0,null,0,null,0]
["Athletic Trainers",0,0,0,0,null,0,null,0,null,0,null,0]
["Managers",0,0,0,0,null,0,null,0,null,0,null,0]
["Summer School",0,0,0,0,null,0,null,0,null,0,null,0]
["5th Year",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Total Other Aid",{"$f":"SUM(B39:B44)","v":0},0,0,0,null,0,null,0,null,0,null,0]
[]
["Total Student Aid",{"$f":"B20+B36+B45","v":2261000},{"$f":"C20+C36+C45","v":2928000},{"$f":"D20+D36+D45","v":2655000},{"$f":"E20+E36+E45","v":2998100},null,{"$f":"G20+G36+G45","v":3072800},null,{"$f":"I20+I36+I45","v":3149300},null,{"$f":"K20+K36+K45","v":3228100},null,{"$f":"M20+M36+M45","v":3309000}]

{"sheet":"Coaching Salaries","index":21,"n_rows":201,"n_cols":14,"rows_kept":201,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Coaching Salaries, Benefits & Bonuses Paid by the University and Related Entities"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
["Men's Sports"]
["Basketball"]
["Salaries",1400000,1500000,1300000,{"$f":"ROUND(C6+(C6*F6),-2)","v":1575000},0.05,{"$f":"ROUND(E6+(E6*H6),-2)","v":1653800},0.05,{"$f":"ROUND(G6+(G6*J6),-2)","v":1736500},0.05,{"$f":"ROUND(I6+(I6*L6),-2)","v":1823300},0.05,{"$f":"ROUND(K6+(K6*N6),-2)","v":1914500},0.05]
["Fringe Benefits",560000,600000,400000,{"$f":"ROUND(C7+(C7*F7),-2)","v":630000},0.05,661500,0.05,694600,0.05,729300,0.05,765800,0.05]
["Other Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Bonuses",40000,50000,40000,51000,0.02,52000,0.02,53000,0.02,54100,0.02,55200,0.02]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Total Men's Basketball Compensation",{"$f":"SUM(B6:B10)","v":2000000},2150000,1740000,2256000,null,2367300,null,2484100,null,2606700,null,2735500]
["Baseball"]
["Salaries",0,0,0,{"$f":"ROUND(C13+(C13*F13),-2)","v":0},null,0,null,0,null,0,null,0]
["Fringe Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Other Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Bonuses",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Total Baseball Compensation",{"$f":"SUM(B13:B17)","v":0},0,0,0,null,0,null,0,null,0,null,0]
["Football"]
["Salaries",2400000,2500000,2200000,{"$f":"ROUND(C20+(C20*F20),-2)","v":2625000},0.05,2756300,0.05,2894100,0.05,3038800,0.05,3190700,0.05]
["Fringe Benefits",960000,1000000,800000,1050000,0.05,1102500,0.05,1157600,0.05,1215500,0.05,1276300,0.05]
["Other Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Bonuses",90000,100000,90000,102000,0.02,104000,0.02,106100,0.02,108200,0.02,110400,0.02]
["Other",0,0,null,0,null,0,null,0,null,0,null,0]
["Total Football Compensation",{"$f":"SUM(B20:B24)","v":3450000},3600000,3090000,3777000,null,3962800,null,4157800,null,4362500,null,4577400]
["Gymnastics"]
["Salaries",0,0,0,{"$f":"ROUND(C27+(C27*F27),-2)","v":0},null,0,null,0,null,0,null,0]
["Fringe Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Other Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Bonuses",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Total Gymnastics Compensation",{"$f":"SUM(B27:B31)","v":0},0,0,0,null,0,null,0,null,0,null,0]
["Golf"]
["Salaries",37000,38000,28000,{"$f":"ROUND(C34+(C34*F34),-2)","v":39900},0.05,41900,0.05,44000,0.05,46200,0.05,48500,0.05]
["Fringe Benefits",11100,11400,8000,12000,0.05,12600,0.05,13200,0.05,13900,0.05,14600,0.05]
["Other Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Bonuses",2000,2000,0,2000,0.02,2000,0.02,2000,0.02,2000,0.02,2000,0.02]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Total Golf Compensation",{"$f":"SUM(B34:B38)","v":50100},51400,36000,53900,null,56500,null,59200,null,62100,null,65100]
["Ice Hockey"]
["Salaries",0,0,0,{"$f":"ROUND(C41+(C41*F41),-2)","v":0},null,0,null,0,null,0,null,0]
["Fringe Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Other Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Bonuses",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Total Ice Hockey Compensation",{"$f":"SUM(B41:B45)","v":0},0,0,0,null,0,null,0,null,0,null,0]
["Lacrosse"]
["Salaries",0,0,0,{"$f":"ROUND(C48+(C48*F48),-2)","v":0},null,0,null,0,null,0,null,0]
["Fringe Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Other Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Bonuses",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Total Lacrosse Compensation",{"$f":"SUM(B48:B52)","v":0},0,0,0,null,0,null,0,null,0,null,0]
["Soccer"]
["Salaries",29000,31000,22000,{"$f":"ROUND(C55+(C55*F55),-2)","v":32600},0.05,34200,0.05,35900,0.05,37700,0.05,39600,0.05]
["Fringe Benefits",8700,9300,6600,9800,0.05,10300,0.05,10800,0.05,11300,0.05,11900,0.05]
["Other Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Bonuses",2000,2000,0,2000,0.02,2000,0.02,2000,0.02,2000,0.02,2000,0.02]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Total Soccer Compensation",{"$f":"SUM(B55:B59)","v":39700},42300,28600,44400,null,46500,null,48700,null,51000,null,53500]
["Swimming"]
["Salaries",57000,59000,42000,{"$f":"ROUND(C62+(C62*F62),-2)","v":62000},0.05,65100,0.05,68400,0.05,71800,0.05,75400,0.05]
["Fringe Benefits",17100,17700,12600,18600,0.05,19500,0.05,20500,0.05,21500,0.05,22600,0.05]
["Other Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Bonuses",4000,4200,0,4300,0.02,4400,0.02,4500,0.02,4600,0.02,4700,0.02]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Total Swimming Compensation",{"$f":"SUM(B62:B66)","v":78100},80900,54600,84900,null,89000,null,93400,null,97900,null,102700]
["Tennis"]
["Salaries",16000,18000,12000,{"$f":"ROUND(C69+(C69*F69),-2)","v":18900},0.05,19800,0.05,20800,0.05,21800,0.05,22900,0.05]
["Fringe Benefits",4800,5400,3600,5700,0.05,6000,0.05,6300,0.05,6600,0.05,6900,0.05]
["Other Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Bonuses",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Total Tennis Compensation",{"$f":"SUM(B69:B73)","v":20800},23400,15600,24600,null,25800,null,27100,null,28400,null,29800]
["Track and Field"]
["Salaries",9500,9500,7000,{"$f":"ROUND(C76+(C76*F76),-2)","v":10000},0.05,10500,0.05,11000,0.05,11600,0.05,12200,0.05]
["Fringe Benefits",2850,2850,2100,3000,0.05,3200,0.05,3400,0.05,3600,0.05,3800,0.05]
["Other Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Bonuses",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Total Track and Field Compensation",{"$f":"SUM(B76:B80)","v":12350},12350,9100,13000,null,13700,null,14400,null,15200,null,16000]
["Volleyball"]
["Salaries",0,0,0,{"$f":"ROUND(C83+(C83*F83),-2)","v":0},null,0,null,0,null,0,null,0]
["Fringe Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Other Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Bonuses",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Total Volleyball Compensation",{"$f":"SUM(B83:B87)","v":0},0,0,0,null,0,null,0,null,0,null,0]
["Wrestling"]
["Salaries",0,0,0,{"$f":"ROUND(C90+(C90*F90),-2)","v":0},null,0,null,0,null,0,null,0]
["Fringe Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Other Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Bonuses",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Total Wrestling Compensation",{"$f":"SUM(B90:B94)","v":0},0,0,0,null,0,null,0,null,0,null,0]
["Other"]
["Salaries",0,0,0,{"$f":"ROUND(C97+(C97*F97),-2)","v":0},null,0,null,0,null,0,null,0]
["Fringe Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Other Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Bonuses",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Total Other Compensation",{"$f":"SUM(B97:B101)","v":0},0,0,0,null,0,null,0,null,0,null,0]
["Total Coaching Salaries-Men's Sports",{"$f":"B11+B18+B25+B32+B39+B46+B53+B60+B67+B74+B81+B88+B95+B102","v":5651050},5960350,4973900,6253800,null,6561600,null,6884700,null,7223800,null,7580000]
[]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1",null,"Year 1",null,"Year 1",null,"Year 1",null,"Year 1"]
["Women's Sports"]
["Basketball"]
["Salaries",74500,75900,62500,{"$f":"ROUND(C109+(C109*F109),-2)","v":79700},0.05,83700,0.05,87900,0.05,92300,0.05,96900,0.05]
["Fringe Benefits",22350,22770,18750,23900,0.05,25100,0.05,26400,0.05,27700,0.05,29100,0.05]
["Other Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Bonuses",2500,2500,0,2600,0.02,2700,0.02,2800,0.02,2900,0.02,3000,0.02]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Total Women's Basketball Compensation",{"$f":"SUM(B109:B113)","v":99350},101170,81250,106200,null,111500,null,117100,null,122900,null,129000]
["Field Hockey"]
["Salaries",0,0,0,{"$f":"ROUND(C116+(C116*F116),-2)","v":0},null,0,null,0,null,0,null,0]
["Fringe Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Other Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Bonuses",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Total Field Hockey Compensation",{"$f":"SUM(B116:B120)","v":0},0,0,0,null,0,null,0,null,0,null,0]
["Golf"]
["Salaries",0,0,0,{"$f":"ROUND(C123+(C123*F123),-2)","v":0},null,0,null,0,null,0,null,0]
["Fringe Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Other Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Bonuses",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Total Field Hockey Compensation",{"$f":"SUM(B123:B127)","v":0},0,0,0,null,0,null,0,null,0,null,0]
["Gymnastics"]
["Salaries",0,0,0,{"$f":"ROUND(C130+(C130*F130),-2)","v":0},null,0,null,0,null,0,null,0]
["Fringe Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Other Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Bonuses",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Total Gymnastics Compensation",{"$f":"SUM(B130:B134)","v":0},0,0,0,null,0,null,0,null,0,null,0]
["Ice Hockey"]
["Salaries",0,0,0,{"$f":"ROUND(C137+(C137*F137),-2)","v":0},null,0,null,0,null,0,null,0]
["Fringe Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Other Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Bonuses",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Total Ice Hockey Compensation",{"$f":"SUM(B137:B141)","v":0},0,0,0,null,0,null,0,null,0,null,0]
["Lacrosse"]
["Salaries",0,0,0,{"$f":"ROUND(C144+(C144*F144),-2)","v":0},null,0,null,0,null,0,null,0]
["Fringe Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Other Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Bonuses",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Total Lacrosse Compensation",{"$f":"SUM(B144:B148)","v":0},0,0,0,null,0,null,0,null,0,null,0]
["Soccer"]
["Salaries",38700,39400,25600,{"$f":"ROUND(C151+(C151*F151),-2)","v":41400},0.05,43500,0.05,45700,0.05,48000,0.05,50400,0.05]
["Fringe Benefits",11610,11820,7680,12400,0.05,13000,0.05,13700,0.05,14400,0.05,15100,0.05]
["Other Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Bonuses",0,1000,0,1000,null,1000,null,1000,null,1000,null,1000]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Total Soccer Compensation",{"$f":"SUM(B151:B155)","v":50310},52220,33280,54800,null,57500,null,60400,null,63400,null,66500]
["Softball"]
["Salaries",35000,36200,22600,{"$f":"ROUND(C158+(C158*F158),-2)","v":38000},0.05,39900,0.05,41900,0.05,44000,0.05,46200,0.05]
["Fringe Benefits",10500,10860,6780,11400,0.05,12000,0.05,12600,0.05,13200,0.05,13900,0.05]
["Other Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Bonuses",500,500,0,500,null,500,null,500,null,500,null,500]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Total Softball Compensation",{"$f":"SUM(B158:B162)","v":46000},47560,29380,49900,null,52400,null,55000,null,57700,null,60600]
["Swimming"]
["Salaries",67000,69000,51000,{"$f":"ROUND(C165+(C165*F165),-2)","v":72500},0.05,76100,0.05,79900,0.05,83900,0.05,88100,0.05]
["Fringe Benefits",20100,20700,15300,21700,0.05,22800,0.05,23900,0.05,25100,0.05,26400,0.05]
["Other Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Bonuses",1500,1500,0,1500,null,1500,null,1500,null,1500,null,1500]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Total Swimming Compensation",{"$f":"SUM(B165:B169)","v":88600},91200,66300,95700,null,100400,null,105300,null,110500,null,116000]
["Tennis"]
["Salaries",25500,28000,15500,{"$f":"ROUND(C172+(C172*F172),-2)","v":29400},0.05,30900,0.05,32400,0.05,34000,0.05,35700,0.05]
["Fringe Benefits",7650,8400,4650,8800,0.05,9200,0.05,9700,0.05,10200,0.05,10700,0.05]
["Other Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Bonuses",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Total Tennis Compensation",{"$f":"SUM(B172:B176)","v":33150},36400,20150,38200,null,40100,null,42100,null,44200,null,46400]
["Track and Field"]
["Salaries",30000,31000,22000,{"$f":"ROUND(C179+(C179*F179),-2)","v":32600},0.05,34200,0.05,35900,0.05,37700,0.05,39600,0.05]
["Fringe Benefits",9000,9300,6600,9800,0.05,10300,0.05,10800,0.05,11300,0.05,11900,0.05]
["Other Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Bonuses",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Total Track and Field Compensation",{"$f":"SUM(B179:B183)","v":39000},40300,28600,42400,null,44500,null,46700,null,49000,null,51500]
["Volleyball"]
["Salaries",40000,41000,30000,{"$f":"ROUND(C186+(C186*F186),-2)","v":43100},0.05,45300,0.05,47600,0.05,50000,0.05,52500,0.05]
["Fringe Benefits",12000,12300,9000,12900,0.05,13500,0.05,14200,0.05,14900,0.05,15600,0.05]
["Other Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Bonuses",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Total Volleyball Compensation",{"$f":"SUM(B186:B190)","v":52000},53300,39000,56000,null,58800,null,61800,null,64900,null,68100]
["Other"]
["Salaries",0,0,0,{"$f":"ROUND(C193+(C193*F193),-2)","v":0},null,0,null,0,null,0,null,0]
["Fringe Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Other Benefits",0,0,0,0,null,0,null,0,null,0,null,0]
["Bonuses",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Total Other Compensation",{"$f":"SUM(B193:B197)","v":0},0,0,0,null,0,null,0,null,0,null,0]
[]
["Total Coaching Salaries-Women's Sports",{"$f":"B114+B121+B128+B135+B142+B149+B156+B163+B170+B177+B184+B191+B198","v":408410},422150,297960,443200,null,465200,null,488400,null,512600,null,538100]
["Total Coaching Salaries",{"$f":"B103+B200","v":6059460},6382500,5271860,6697000,null,7026800,null,7373100,null,7736400,null,8118100]

{"sheet":"Coaching Comp.","index":22,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Coaching Compensation and Benefits Paid by a Third Party"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
[]
["Men's Sports"]
["Basketball",9000,50000,5000,{"$f":"ROUND(C6+(C6*F6),-2)","v":32500},-0.35,{"$f":"ROUND(E6+(E6*H6),-2)","v":34100},0.05,{"$f":"ROUND(G6+(G6*J6),-2)","v":35800},0.05,{"$f":"ROUND(I6+(I6*L6),-2)","v":37600},0.05,{"$f":"ROUND(K6+(K6*N6),-2)","v":39500},0.05]
["Baseball",0,0,0,{"$f":"ROUND(C7+(C7*F7),-2)","v":0},null,0,null,0,null,0,null,0]
["Football",28000,100000,20000,85000,-0.15,87600,0.03,90200,0.03,92900,0.03,95700,0.03]
["Gymnastics",0,0,0,0,null,0,null,0,null,0,null,0]
["Golf",0,0,0,0,null,0,null,0,null,0,null,0]
["Ice Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Lacrosse",0,0,0,0,null,0,null,0,null,0,null,0]
["Soccer",0,0,0,0,null,0,null,0,null,0,null,0]
["Swimming",0,0,0,0,null,0,null,0,null,0,null,0]
["Tennis",0,0,0,0,null,0,null,0,null,0,null,0]
["Track and Field",0,0,0,0,null,0,null,0,null,0,null,0]
["Volleyball",0,0,0,0,null,0,null,0,null,0,null,0]
["Wrestling",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
[]
["Women's Sports"]
["Basketball",0,25000,0,{"$f":"ROUND(C22+(C22*F22),-2)","v":18800},-0.25,19700,0.05,20700,0.05,21700,0.05,22800,0.05]
["Field Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Golf",0,0,0,0,null,0,null,0,null,0,null,0]
["Gymnastics",0,0,0,0,null,0,null,0,null,0,null,0]
["Ice Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Lacrosse",0,0,0,0,null,0,null,0,null,0,null,0]
["Soccer",0,0,0,0,null,0,null,0,null,0,null,0]
["Softball",0,0,0,0,null,0,null,0,null,0,null,0]
["Swimming",0,0,0,0,null,0,null,0,null,0,null,0]
["Tennis",0,0,0,0,null,0,null,0,null,0,null,0]
["Track and Field",0,0,0,0,null,0,null,0,null,0,null,0]
["Volleyball",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
[]
["Total 3rd Party Compensation",{"$f":"SUM(B6:B34)","v":37000},175000,{"$f":"SUM(D6:D34)","v":25000},136300,null,141400,null,146700,null,152200,null,158000]

{"sheet":"Support Salaries","index":23,"n_rows":72,"n_cols":14,"rows_kept":72,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Support Staff/Administrative Salaries, Benefits & Bonuses paid by the University and Related Entities"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
[]
["Academic Advisors"]
["Salaries",200000,225000,190000,{"$f":"ROUND(C6+(C6*F6),-2)","v":229500},0.02,{"$f":"ROUND(E6+(E6*H6),-2)","v":241000},0.05,{"$f":"ROUND(G6+(G6*J6),-2)","v":253100},0.05,{"$f":"ROUND(I6+(I6*L6),-2)","v":265800},0.05,{"$f":"ROUND(K6+(K6*N6),-2)","v":279100},0.05]
["Benefits",80000,90000,76000,{"$f":"ROUND(C7+(C7*F7),-2)","v":94500},0.05,99200,0.05,104200,0.05,109400,0.05,114900,0.05]
["Bonuses",0,0,0,0,null,0,null,0,null,0,null,0]
["Total Compensation",{"$f":"SUM(B6:B8)","v":280000},315000,266000,324000,null,340200,null,357300,null,375200,null,394000]
["Athletic Administration"]
["Salaries",550000,600000,500000,{"$f":"ROUND(C11+(C11*F11),-2)","v":612000},0.02,{"$f":"ROUND(E11+(E11*H11),-2)","v":642600},0.05,{"$f":"ROUND(G11+(G11*J11),-2)","v":674700},0.05,{"$f":"ROUND(I11+(I11*L11),-2)","v":708400},0.05,{"$f":"ROUND(K11+(K11*N11),-2)","v":743800},0.05]
["Benefits",220000,240000,200000,{"$f":"ROUND(C12+(C12*F12),-2)","v":252000},0.05,{"$f":"ROUND(E12+(E12*H12),-2)","v":264600},0.05,{"$f":"ROUND(G12+(G12*J12),-2)","v":277800},0.05,{"$f":"ROUND(I12+(I12*L12),-2)","v":291700},0.05,{"$f":"ROUND(K12+(K12*N12),-2)","v":306300},0.05]
["Bonuses",50000,50000,0,{"$f":"ROUND(C13+(C13*F13),-2)","v":50000},null,{"$f":"ROUND(E13+(E13*H13),-2)","v":50000},null,{"$f":"ROUND(G13+(G13*J13),-2)","v":50000},null,{"$f":"ROUND(I13+(I13*L13),-2)","v":50000},null,{"$f":"ROUND(K13+(K13*N13),-2)","v":50000}]
["Total Compensation",{"$f":"SUM(B11:B13)","v":820000},890000,700000,914000,null,957200,null,1002500,null,1050100,null,1100100]
["Athletic Compliance"]
["Salaries",200000,210000,218000,{"$f":"ROUND(C16+(C16*F16),-2)","v":214200},0.02,{"$f":"ROUND(E16+(E16*H16),-2)","v":224900},0.05,{"$f":"ROUND(G16+(G16*J16),-2)","v":236100},0.05,{"$f":"ROUND(I16+(I16*L16),-2)","v":247900},0.05,{"$f":"ROUND(K16+(K16*N16),-2)","v":260300},0.05]
["Benefits",80000,84000,87000,{"$f":"ROUND(C17+(C17*F17),-2)","v":88200},0.05,{"$f":"ROUND(E17+(E17*H17),-2)","v":92600},0.05,{"$f":"ROUND(G17+(G17*J17),-2)","v":97200},0.05,{"$f":"ROUND(I17+(I17*L17),-2)","v":102100},0.05,{"$f":"ROUND(K17+(K17*N17),-2)","v":107200},0.05]
["Bonuses",0,0,0,{"$f":"ROUND(C18+(C18*F18),-2)","v":0},null,{"$f":"ROUND(E18+(E18*H18),-2)","v":0},null,{"$f":"ROUND(G18+(G18*J18),-2)","v":0},null,{"$f":"ROUND(I18+(I18*L18),-2)","v":0},null,{"$f":"ROUND(K18+(K18*N18),-2)","v":0}]
["Total Compensation",{"$f":"SUM(B16:B18)","v":280000},294000,305000,302400,null,317500,null,333300,null,350000,null,367500]
["Sports Information"]
["Salaries",0,0,0,{"$f":"ROUND(C21+(C21*F21),-2)","v":0},null,{"$f":"ROUND(E21+(E21*H21),-2)","v":0},null,{"$f":"ROUND(G21+(G21*J21),-2)","v":0},null,{"$f":"ROUND(I21+(I21*L21),-2)","v":0},null,{"$f":"ROUND(K21+(K21*N21),-2)","v":0}]
["Benefits",0,0,0,{"$f":"ROUND(C22+(C22*F22),-2)","v":0},null,0,null,0,null,0,null,0]
["Bonuses",0,0,0,0,null,0,null,0,null,0,null,0]
["Total Compensation",{"$f":"SUM(B21:B23)","v":0},0,0,0,null,0,null,0,null,0,null,0]
["Sports Medicine"]
["Salaries",788000,800000,832000,{"$f":"ROUND(C26+(C26*F26),-2)","v":816000},0.02,{"$f":"ROUND(E26+(E26*H26),-2)","v":856800},0.05,{"$f":"ROUND(G26+(G26*J26),-2)","v":899600},0.05,{"$f":"ROUND(I26+(I26*L26),-2)","v":944600},0.05,{"$f":"ROUND(K26+(K26*N26),-2)","v":991800},0.05]
["Benefits",315000,320000,332000,{"$f":"ROUND(C27+(C27*F27),-2)","v":336000},0.05,{"$f":"ROUND(E27+(E27*H27),-2)","v":352800},0.05,{"$f":"ROUND(G27+(G27*J27),-2)","v":370400},0.05,{"$f":"ROUND(I27+(I27*L27),-2)","v":388900},0.05,{"$f":"ROUND(K27+(K27*N27),-2)","v":408300},0.05]
["Bonuses",0,0,0,{"$f":"ROUND(C28+(C28*F28),-2)","v":0},null,{"$f":"ROUND(E28+(E28*H28),-2)","v":0},null,{"$f":"ROUND(G28+(G28*J28),-2)","v":0},null,{"$f":"ROUND(I28+(I28*L28),-2)","v":0},null,{"$f":"ROUND(K28+(K28*N28),-2)","v":0}]
["Total Compensation",{"$f":"SUM(B26:B28)","v":1103000},1120000,1164000,1152000,null,1209600,null,1270000,null,1333500,null,1400100]
["Marketing"]
["Salaries",115000,130000,135000,{"$f":"ROUND(C31+(C31*F31),-2)","v":132600},0.02,{"$f":"ROUND(E31+(E31*H31),-2)","v":139200},0.05,{"$f":"ROUND(G31+(G31*J31),-2)","v":146200},0.05,{"$f":"ROUND(I31+(I31*L31),-2)","v":153500},0.05,{"$f":"ROUND(K31+(K31*N31),-2)","v":161200},0.05]
["Benefits",46000,52000,54000,{"$f":"ROUND(C32+(C32*F32),-2)","v":54600},0.05,{"$f":"ROUND(E32+(E32*H32),-2)","v":57300},0.05,{"$f":"ROUND(G32+(G32*J32),-2)","v":60200},0.05,{"$f":"ROUND(I32+(I32*L32),-2)","v":63200},0.05,{"$f":"ROUND(K32+(K32*N32),-2)","v":66400},0.05]
["Bonuses",0,0,0,{"$f":"ROUND(C33+(C33*F33),-2)","v":0},null,{"$f":"ROUND(E33+(E33*H33),-2)","v":0},null,{"$f":"ROUND(G33+(G33*J33),-2)","v":0},null,{"$f":"ROUND(I33+(I33*L33),-2)","v":0},null,{"$f":"ROUND(K33+(K33*N33),-2)","v":0}]
["Total Compensation",{"$f":"SUM(B31:B33)","v":161000},182000,189000,187200,null,196500,null,206400,null,216700,null,227600]
["Strength and Conditioning"]
["Salaries",200000,210000,218000,{"$f":"ROUND(C36+(C36*F36),-2)","v":214200},0.02,{"$f":"ROUND(E36+(E36*H36),-2)","v":224900},0.05,{"$f":"ROUND(G36+(G36*J36),-2)","v":236100},0.05,{"$f":"ROUND(I36+(I36*L36),-2)","v":247900},0.05,{"$f":"ROUND(K36+(K36*N36),-2)","v":260300},0.05]
["Benefits",80000,84000,87000,{"$f":"ROUND(C37+(C37*F37),-2)","v":88200},0.05,{"$f":"ROUND(E37+(E37*H37),-2)","v":92600},0.05,{"$f":"ROUND(G37+(G37*J37),-2)","v":97200},0.05,{"$f":"ROUND(I37+(I37*L37),-2)","v":102100},0.05,{"$f":"ROUND(K37+(K37*N37),-2)","v":107200},0.05]
["Bonuses",0,0,0,{"$f":"ROUND(C38+(C38*F38),-2)","v":0},null,{"$f":"ROUND(E38+(E38*H38),-2)","v":0},null,{"$f":"ROUND(G38+(G38*J38),-2)","v":0},null,{"$f":"ROUND(I38+(I38*L38),-2)","v":0},null,{"$f":"ROUND(K38+(K38*N38),-2)","v":0}]
["Total Compensation",{"$f":"SUM(B36:B38)","v":280000},294000,305000,302400,null,317500,null,333300,null,350000,null,367500]
["Ticket Office"]
["Salaries",122000,130000,135000,{"$f":"ROUND(C41+(C41*F41),-2)","v":132600},0.02,{"$f":"ROUND(E41+(E41*H41),-2)","v":139200},0.05,{"$f":"ROUND(G41+(G41*J41),-2)","v":146200},0.05,{"$f":"ROUND(I41+(I41*L41),-2)","v":153500},0.05,{"$f":"ROUND(K41+(K41*N41),-2)","v":161200},0.05]
["Benefits",8000,52000,54000,{"$f":"ROUND(C42+(C42*F42),-2)","v":54600},0.05,{"$f":"ROUND(E42+(E42*H42),-2)","v":57300},0.05,{"$f":"ROUND(G42+(G42*J42),-2)","v":60200},0.05,{"$f":"ROUND(I42+(I42*L42),-2)","v":63200},0.05,{"$f":"ROUND(K42+(K42*N42),-2)","v":66400},0.05]
["Bonuses",0,0,0,{"$f":"ROUND(C43+(C43*F43),-2)","v":0},null,{"$f":"ROUND(E43+(E43*H43),-2)","v":0},null,{"$f":"ROUND(G43+(G43*J43),-2)","v":0},null,{"$f":"ROUND(I43+(I43*L43),-2)","v":0},null,{"$f":"ROUND(K43+(K43*N43),-2)","v":0}]
["Total Compensation",{"$f":"SUM(B41:B43)","v":130000},182000,189000,187200,null,196500,null,206400,null,216700,null,227600]
["Business Office"]
["Salaries",155000,160000,166000,{"$f":"ROUND(C46+(C46*F46),-2)","v":163200},0.02,{"$f":"ROUND(E46+(E46*H46),-2)","v":171400},0.05,{"$f":"ROUND(G46+(G46*J46),-2)","v":180000},0.05,{"$f":"ROUND(I46+(I46*L46),-2)","v":189000},0.05,{"$f":"ROUND(K46+(K46*N46),-2)","v":198500},0.05]
["Benefits",0,64000,66000,{"$f":"ROUND(C47+(C47*F47),-2)","v":67200},0.05,{"$f":"ROUND(E47+(E47*H47),-2)","v":70600},0.05,{"$f":"ROUND(G47+(G47*J47),-2)","v":74100},0.05,{"$f":"ROUND(I47+(I47*L47),-2)","v":77800},0.05,{"$f":"ROUND(K47+(K47*N47),-2)","v":81700},0.05]
["Bonuses",0,0,0,{"$f":"ROUND(C48+(C48*F48),-2)","v":0},null,{"$f":"ROUND(E48+(E48*H48),-2)","v":0},null,{"$f":"ROUND(G48+(G48*J48),-2)","v":0},null,{"$f":"ROUND(I48+(I48*L48),-2)","v":0},null,{"$f":"ROUND(K48+(K48*N48),-2)","v":0}]
["Total Compensation",{"$f":"SUM(B46:B48)","v":155000},224000,232000,230400,null,242000,null,254100,null,266800,null,280200]
["Development"]
["Salaries",135000,140000,145000,{"$f":"ROUND(C51+(C51*F51),-2)","v":142800},0.02,{"$f":"ROUND(E51+(E51*H51),-2)","v":149900},0.05,{"$f":"ROUND(G51+(G51*J51),-2)","v":157400},0.05,{"$f":"ROUND(I51+(I51*L51),-2)","v":165300},0.05,{"$f":"ROUND(K51+(K51*N51),-2)","v":173600},0.05]
["Benefits",54000,56000,58000,{"$f":"ROUND(C52+(C52*F52),-2)","v":58800},0.05,{"$f":"ROUND(E52+(E52*H52),-2)","v":61700},0.05,{"$f":"ROUND(G52+(G52*J52),-2)","v":64800},0.05,{"$f":"ROUND(I52+(I52*L52),-2)","v":68000},0.05,{"$f":"ROUND(K52+(K52*N52),-2)","v":71400},0.05]
["Bonuses",0,0,0,{"$f":"ROUND(C53+(C53*F53),-2)","v":0},null,{"$f":"ROUND(E53+(E53*H53),-2)","v":0},null,{"$f":"ROUND(G53+(G53*J53),-2)","v":0},null,{"$f":"ROUND(I53+(I53*L53),-2)","v":0},null,{"$f":"ROUND(K53+(K53*N53),-2)","v":0}]
["Total Compensation",{"$f":"SUM(B51:B53)","v":189000},196000,203000,201600,null,211600,null,222200,null,233300,null,245000]
["Athletic Director"]
["Salaries",135000,140000,145000,{"$f":"ROUND(C56+(C56*F56),-2)","v":142800},0.02,{"$f":"ROUND(E56+(E56*H56),-2)","v":149900},0.05,{"$f":"ROUND(G56+(G56*J56),-2)","v":157400},0.05,{"$f":"ROUND(I56+(I56*L56),-2)","v":165300},0.05,{"$f":"ROUND(K56+(K56*N56),-2)","v":173600},0.05]
["Benefits",54000,56000,58000,{"$f":"ROUND(C57+(C57*F57),-2)","v":58800},0.05,{"$f":"ROUND(E57+(E57*H57),-2)","v":61700},0.05,{"$f":"ROUND(G57+(G57*J57),-2)","v":64800},0.05,{"$f":"ROUND(I57+(I57*L57),-2)","v":68000},0.05,{"$f":"ROUND(K57+(K57*N57),-2)","v":71400},0.05]
["Bonuses",0,50000,0,{"$f":"ROUND(C58+(C58*F58),-2)","v":50000},null,{"$f":"ROUND(E58+(E58*H58),-2)","v":50000},null,{"$f":"ROUND(G58+(G58*J58),-2)","v":50000},null,{"$f":"ROUND(I58+(I58*L58),-2)","v":50000},null,{"$f":"ROUND(K58+(K58*N58),-2)","v":50000}]
["Total Compensation",{"$f":"SUM(B56:B58)","v":189000},246000,203000,251600,null,261600,null,272200,null,283300,null,295000]
["Facilities"]
["Salaries",75000,80000,83000,{"$f":"ROUND(C61+(C61*F61),-2)","v":81600},0.02,{"$f":"ROUND(E61+(E61*H61),-2)","v":85700},0.05,{"$f":"ROUND(G61+(G61*J61),-2)","v":90000},0.05,{"$f":"ROUND(I61+(I61*L61),-2)","v":94500},0.05,{"$f":"ROUND(K61+(K61*N61),-2)","v":99200},0.05]
["Benefits",30000,32000,33000,{"$f":"ROUND(C62+(C62*F62),-2)","v":33600},0.05,{"$f":"ROUND(E62+(E62*H62),-2)","v":35300},0.05,{"$f":"ROUND(G62+(G62*J62),-2)","v":37100},0.05,{"$f":"ROUND(I62+(I62*L62),-2)","v":39000},0.05,{"$f":"ROUND(K62+(K62*N62),-2)","v":41000},0.05]
["Bonuses",0,0,0,{"$f":"ROUND(C63+(C63*F63),-2)","v":0},null,{"$f":"ROUND(E63+(E63*H63),-2)","v":0},null,{"$f":"ROUND(G63+(G63*J63),-2)","v":0},null,{"$f":"ROUND(I63+(I63*L63),-2)","v":0},null,{"$f":"ROUND(K63+(K63*N63),-2)","v":0}]
["Total Compensation",{"$f":"SUM(B61:B63)","v":105000},112000,116000,115200,null,121000,null,127100,null,133500,null,140200]
["Other"]
["Salaries",85000,90000,93000,{"$f":"ROUND(C66+(C66*F66),-2)","v":91800},0.02,{"$f":"ROUND(E66+(E66*H66),-2)","v":96400},0.05,{"$f":"ROUND(G66+(G66*J66),-2)","v":101200},0.05,{"$f":"ROUND(I66+(I66*L66),-2)","v":106300},0.05,{"$f":"ROUND(K66+(K66*N66),-2)","v":111600},0.05]
["Benefits",34000,36000,37000,{"$f":"ROUND(C67+(C67*F67),-2)","v":37800},0.05,{"$f":"ROUND(E67+(E67*H67),-2)","v":39700},0.05,{"$f":"ROUND(G67+(G67*J67),-2)","v":41700},0.05,{"$f":"ROUND(I67+(I67*L67),-2)","v":43800},0.05,{"$f":"ROUND(K67+(K67*N67),-2)","v":46000},0.05]
["Bonuses",0,0,0,{"$f":"ROUND(C68+(C68*F68),-2)","v":0},null,{"$f":"ROUND(E68+(E68*H68),-2)","v":0},null,{"$f":"ROUND(G68+(G68*J68),-2)","v":0},null,{"$f":"ROUND(I68+(I68*L68),-2)","v":0},null,{"$f":"ROUND(K68+(K68*N68),-2)","v":0}]
["Total Compensation",{"$f":"SUM(B66:B68)","v":119000},126000,130000,129600,null,136100,null,142900,null,150100,null,157600]
[]
[]
["Total Support Staff/Admin Salaries",{"$f":"B9+B14+B19+B24+B29+B34+B39+B44+B49+B54+B59+B64+B69","v":3811000},4181000,4002000,4297600,null,4507300,null,4727700,null,4959200,null,5202400]

{"sheet":"Support Comp.","index":24,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Support Staff/Administrative Benefits & Bonuses paid by a Third Party"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
[]
["Academic Advisors",0,0,0,{"$f":"ROUND(C5+(C5*F5),-2)","v":0},null,{"$f":"ROUND(E5+(E5*H5),-2)","v":0},null,{"$f":"ROUND(G5+(G5*J5),-2)","v":0},null,{"$f":"ROUND(I5+(I5*L5),-2)","v":0},null,{"$f":"ROUND(K5+(K5*N5),-2)","v":0}]
["Athletic Administration",0,0,0,{"$f":"ROUND(C6+(C6*F6),-2)","v":0},null,0,null,0,null,0,null,0]
["Athletic Compliance",0,0,0,0,null,0,null,0,null,0,null,0]
["Public Relations",0,0,0,0,null,0,null,0,null,0,null,0]
["Sports Medicine",0,0,0,0,null,0,null,0,null,0,null,0]
["Sports Promotion",0,0,0,0,null,0,null,0,null,0,null,0]
["Strength and Conditioning",0,0,0,0,null,0,null,0,null,0,null,0]
["Student-Athlete Services",0,0,0,0,null,0,null,0,null,0,null,0]
["Ticket Office",0,0,0,0,null,0,null,0,null,0,null,0]
["Business Office",0,0,0,0,null,0,null,0,null,0,null,0]
["Development",0,0,0,0,null,0,null,0,null,0,null,0]
["Athletic Director",0,0,0,0,null,0,null,0,null,0,null,0]
["Facilities",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
[]
["Total Third Party Compensation",{"$f":"SUM(B5:B19)","v":0},0,0,0,null,0,null,0,null,0,null,0]

{"sheet":"Severance","index":25,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Severance Payments"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
[]
["Person A",0,0,0,{"$f":"ROUND(C5+(C5*F5),-2)","v":0},null,{"$f":"ROUND(E5+(E5*H5),-2)","v":0},null,{"$f":"ROUND(G5+(G5*J5),-2)","v":0},null,{"$f":"ROUND(I5+(I5*L5),-2)","v":0},null,{"$f":"ROUND(K5+(K5*N5),-2)","v":0}]
["Person B",0,100000,100000,{"$f":"ROUND(C6+(C6*F6),-2)","v":100000},null,100000,null,100000,null,100000,null,100000]
["Person C",0,0,0,0,null,0,null,0,null,0,null,0]
[]
[]
["Total Severance Payments",{"$f":"SUM(B5:B9)","v":0},100000,{"$f":"SUM(D5:D9)","v":100000},100000,null,100000,null,100000,null,100000,null,100000]

{"sheet":"Recruiting","index":26,"n_rows":42,"n_cols":14,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Recruiting"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
["Men's Sports"]
["Basketball",145000,150000,140000,{"$f":"ROUND(C5+(C5*F5),-2)","v":160500},7.0000000000000007E-2,{"$f":"ROUND(E5+(E5*H5),-2)","v":171700},7.0000000000000007E-2,{"$f":"ROUND(G5+(G5*J5),-2)","v":183700},7.0000000000000007E-2,{"$f":"ROUND(I5+(I5*L5),-2)","v":196600},7.0000000000000007E-2,{"$f":"ROUND(K5+(K5*N5),-2)","v":210400},7.0000000000000007E-2]
["Baseball",9000,10085,10000,{"$f":"ROUND(C6+(C6*F6),-2)","v":10800},7.0000000000000007E-2,11600,7.0000000000000007E-2,12400,7.0000000000000007E-2,13300,7.0000000000000007E-2,14200,7.0000000000000007E-2]
["Football",230000,250000,240000,267500,7.0000000000000007E-2,286200,7.0000000000000007E-2,306200,7.0000000000000007E-2,327600,7.0000000000000007E-2,350500,7.0000000000000007E-2]
["Gymnastics",0,0,0,0,null,0,null,0,null,0,null,0]
["Golf",4500,4900,4000,4900,null,4900,null,4900,null,4900,null,4900]
["Ice Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Lacrosse",0,0,0,0,null,0,null,0,null,0,null,0]
["Soccer",5200,5500,5000,5500,null,5500,null,5500,null,5500,null,5500]
["Swimming",5100,5000,6000,5000,null,5000,null,5000,null,5000,null,5000]
["Tennis",0,0,0,0,null,0,null,0,null,0,null,0]
["Track and Field",0,0,0,0,null,0,null,0,null,0,null,0]
["Volleyball",0,0,0,0,null,0,null,0,null,0,null,0]
["Wrestling",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["In-Kind Value of Transportation Services",1000,1200,1000,1200,null,1200,null,1200,null,1200,null,1200]
[]
["Women's Sports"]
["Basketball",38000,50000,48000,{"$f":"ROUND(C22+(C22*F22),-2)","v":53500},7.0000000000000007E-2,57200,7.0000000000000007E-2,61200,7.0000000000000007E-2,65500,7.0000000000000007E-2,70100,7.0000000000000007E-2]
["Field Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Golf",0,0,0,0,null,0,null,0,null,0,null,0]
["Gymnastics",0,0,0,0,null,0,null,0,null,0,null,0]
["Ice Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Lacrosse",0,0,0,0,null,0,null,0,null,0,null,0]
["Soccer",5800,6100,5000,6100,null,6100,null,6100,null,6100,null,6100]
["Softball",9200,9800,8000,9800,null,9800,null,9800,null,9800,null,9800]
["Swimming",3600,4000,4000,4000,null,4000,null,4000,null,4000,null,4000]
["Tennis",280,300,300,300,null,300,null,300,null,300,null,300]
["Track and Field",1300,1500,1400,1500,null,1500,null,1500,null,1500,null,1500]
["Volleyball",9500,15000,9000,15000,null,15000,null,15000,null,15000,null,15000]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["In-Kind Value of Transportation Services",400,500,400,500,null,500,null,500,null,500,null,500]
[]
["Total Recruiting Expenses",{"$f":"SUM(B5:B35)","v":467880},513885,482100,546100,null,580500,null,617300,null,656800,null,699000]
[]
["Total In-Kind Value of Transportation Services",{"$f":"B19+B35","v":1400},1700,1400,1700,null,1700,null,1700,null,1700,null,1700]
["Total Recruiting Expenses less In-Kind Value*",{"$f":"B37-B39","v":466480},512185,480700,544400,null,578800,null,615600,null,655100,null,697300]
[]
["*Fills to Summary #2"]

{"sheet":"Team Travel","index":27,"n_rows":44,"n_cols":14,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Team Travel"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
[]
["Men's Sports"]
["Basketball",720000,750000,690000,{"$f":"ROUND(C6+(C6*F6),-2)","v":900000},0.2,945000,0.05,992300,0.05,1041900,0.05,1094000,0.05]
["Baseball",92000,100000,88000,105000,0.05,110300,0.05,115800,0.05,121600,0.05,127700,0.05]
["Football",1200000,1280000,1150000,1344000,0.05,1411200,0.05,1481800,0.05,1555900,0.05,1633700,0.05]
["Gymnastics",0,0,0,0,null,0,null,0,null,0,null,0]
["Golf",9000,10000,8000,10000,null,10000,null,10000,null,10000,null,10000]
["Ice Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Lacrosse",0,0,0,0,null,0,null,0,null,0,null,0]
["Soccer",8150,15000,8800,15000,null,15000,null,15000,null,15000,null,15000]
["Swimming",14525,20000,12900,20000,null,20000,null,20000,null,20000,null,20000]
["Tennis",0,0,0,0,null,0,null,0,null,0,null,0]
["Track and Field",0,0,0,0,null,0,null,0,null,0,null,0]
["Volleyball",0,0,0,0,null,0,null,0,null,0,null,0]
["Wrestling",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
[]
["Total Travel Expenses-Men's Sports",{"$f":"SUM(B6:B20)","v":2043675},2175000,1957700,2394000,null,2511500,null,2634900,null,2764400,null,2900400]
["Women's Sports"]
["Basketball",290000,300000,280000,{"$f":"ROUND(C23+(C23*F23),-2)","v":360000},0.2,378000,0.05,396900,0.05,416700,0.05,437500,0.05]
["Field Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Golf",0,0,0,0,null,0,null,0,null,0,null,0]
["Gymnastics",0,0,0,0,null,0,null,0,null,0,null,0]
["Ice Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Lacrosse",0,0,0,0,null,0,null,0,null,0,null,0]
["Soccer",12000,15000,8800,15000,null,15000,null,15000,null,15000,null,15000]
["Softball",9000,10000,9000,10000,null,10000,null,10000,null,10000,null,10000]
["Swimming",14525,20000,12900,20000,null,20000,null,20000,null,20000,null,20000]
["Tennis",3500,5000,2900,5000,null,5000,null,5000,null,5000,null,5000]
["Track and Field",12000,15000,9000,15000,null,15000,null,15000,null,15000,null,15000]
["Volleyball",9000,10000,8000,10000,null,10000,null,10000,null,10000,null,10000]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
[]
["Total Travel Expenses-Women's Sports",{"$f":"SUM(B23:B36)","v":350025},375000,330600,435000,null,453000,null,471900,null,491700,null,512500]
[]
["Total Men's and Women's Team Travel Expenses",{"$f":"B37+B21","v":2393700},2550000,2288300,2829000,null,2964500,null,3106800,null,3256100,null,3412900]
[]
["Total Men's and Women's Team Travel In-Kind Value",7300,7550,6900,{"$f":"ROUND(C41+(C41*F41),-2)","v":7900},0.05,8300,0.05,8700,0.05,9100,0.05,9600,0.05]
["Total Men's and Women's Team Travel less In-Kind Value*",{"$f":"B39-B41","v":2386400},2542450,2281400,2821100,null,2956200,null,3098100,null,3247000,null,3403300]
[]
["*Fills to Summary #2"]

{"sheet":"Equipment","index":28,"n_rows":45,"n_cols":14,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Equipment, Uniforms and Supplies"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
[]
["Men's Sports"]
["Basketball",70000,75000,70000,{"$f":"ROUND(C6+(C6*F6),-2)","v":77300},0.03,79600,0.03,82000,0.03,84500,0.03,87000,0.03]
["Baseball",32000,35000,32000,36100,0.03,37200,0.03,38300,0.03,39400,0.03,40600,0.03]
["Football",190000,200000,190000,206000,0.03,212200,0.03,218600,0.03,225200,0.03,232000,0.03]
["Gymnastics",0,0,0,0,null,0,null,0,null,0,null,0]
["Golf",11000,12500,12000,12900,0.03,13300,0.03,13700,0.03,14100,0.03,14500,0.03]
["Ice Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Lacrosse",0,0,0,0,null,0,null,0,null,0,null,0]
["Soccer",12000,15000,6500,15500,0.03,16000,0.03,16500,0.03,17000,0.03,17500,0.03]
["Swimming",10000,12000,10000,12400,0.03,12800,0.03,13200,0.03,13600,0.03,14000,0.03]
["Tennis",6000,7000,6000,7200,0.03,7400,0.03,7600,0.03,7800,0.03,8000,0.03]
["Track and Field",0,0,0,0,null,0,null,0,null,0,null,0]
["Volleyball",0,0,0,0,null,0,null,0,null,0,null,0]
["Wrestling",0,0,0,0,null,0,null,0,null,0,null,0]
["In-Kind Value",45000,50000,48000,51500,0.03,53000,0.03,54600,0.03,56200,0.03,57900,0.03]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
[]
["Women's Sports"]
["Basketball",65000,70000,62000,{"$f":"ROUND(C23+(C23*F23),-2)","v":72100},0.03,74300,0.03,76500,0.03,78800,0.03,81200,0.03]
["Field Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Golf",0,0,0,0,null,0,null,0,null,0,null,0]
["Gymnastics",0,0,0,0,null,0,null,0,null,0,null,0]
["Ice Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Lacrosse",0,0,0,0,null,0,null,0,null,0,null,0]
["Soccer",12000,15000,7000,15500,0.03,16000,0.03,16500,0.03,17000,0.03,17500,0.03]
["Softball",32000,35000,21000,36100,0.03,37200,0.03,38300,0.03,39400,0.03,40600,0.03]
["Swimming",10000,12000,7000,12400,0.03,12800,0.03,13200,0.03,13600,0.03,14000,0.03]
["Tennis",6000,7000,6500,7200,0.03,7400,0.03,7600,0.03,7800,0.03,8000,0.03]
["Track and Field",18000,20000,12000,20600,0.03,21200,0.03,21800,0.03,22500,0.03,23200,0.03]
["Volleyball",38000,40000,35000,41200,0.03,42400,0.03,43700,0.03,45000,0.03,46400,0.03]
["In-Kind Value",28000,30000,25000,30900,0.03,31800,0.03,32800,0.03,33800,0.03,34800,0.03]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
[]
[]
["Total Equipment, Uniforms & Supplies",{"$f":"SUM(B6:B38)-B19","v":540000},{"$f":"SUM(C6:C38)-C19","v":585500},{"$f":"SUM(D6:D38)-D19","v":502000},{"$f":"SUM(E6:E38)","v":654900},null,{"$f":"SUM(G6:G38)","v":674600},null,{"$f":"SUM(I6:I38)","v":694900},null,{"$f":"SUM(K6:K38)","v":715700},null,{"$f":"SUM(M6:M38)","v":737200}]
[]
["Total In-Kind Value",{"$f":"B19+B35","v":73000},80000,73000,82400,null,84800,null,87400,null,90000,null,92700]
[]
["Total Equipment less In-Kind Value*",{"$f":"B39-B41","v":467000},505500,429000,572500,null,589800,null,607500,null,625700,null,644500]
[]
["*Fills to Summary #2"]

{"sheet":"Game Expenses","index":29,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Game Expenses"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
[]
["Ambulance",22000,25000,23000,{"$f":"ROUND(C5+(C5*F5),-2)","v":25800},0.03,26600,0.03,27400,0.03,28200,0.03,29000,0.03]
["Event Staff",325000,350000,342000,360500,0.03,371300,0.03,382400,0.03,393900,0.03,405700,0.03]
["Security",62000,65000,62000,67000,0.03,69000,0.03,71100,0.03,73200,0.03,75400,0.03]
["Officials (prefilled from next sheet)",{"$f":"SUM(Officials!B36)","v":256000},{"$f":"SUM(Officials!C36)","v":297850},{"$f":"SUM(Officials!D36)","v":234300},{"$f":"SUM(Officials!E36)","v":283100},null,{"$f":"SUM(Officials!G36)","v":316400},null,{"$f":"SUM(Officials!I36)","v":353900},null,{"$f":"SUM(Officials!K36)","v":396400},null,{"$f":"SUM(Officials!M36)","v":444700}]
[]
["Total Game Expenses",{"$f":"SUM(B5:B9)","v":665000},737850,{"$f":"SUM(D5:D9)","v":661300},736400,null,783300,null,834800,null,891700,null,954800]

{"sheet":"Officials","index":30,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Officials"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
[]
["Men's Sports"]
["Basketball",50000,52000,48000,{"$f":"ROUND(C6+(C6*F6),-2)","v":49400},-0.05,59300,0.2,71200,0.2,85400,0.2,102500,0.2]
["Baseball",6000,7250,7000,6900,-0.05,7600,0.1,8400,0.1,9200,0.1,10100,0.1]
["Football",120000,125000,100000,118800,-0.05,130700,0.1,143800,0.1,158200,0.1,174000,0.1]
["Gymnastics",0,0,0,0,null,0,null,0,null,0,null,0]
["Golf",3200,4000,2800,3800,-0.05,4200,0.1,4600,0.1,5100,0.1,5600,0.1]
["Ice Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Lacrosse",0,0,0,0,null,0,null,0,null,0,null,0]
["Soccer",6000,8800,6200,8400,-0.05,9200,0.1,10100,0.1,11100,0.1,12200,0.1]
["Swimming",3200,6000,3000,5700,-0.05,6300,0.1,6900,0.1,7600,0.1,8400,0.1]
["Tennis",1800,2000,1500,1900,-0.05,2100,0.1,2300,0.1,2500,0.1,2800,0.1]
["Track and Field",0,0,0,0,null,0,null,0,null,0,null,0]
["Volleyball",0,0,0,0,null,0,null,0,null,0,null,0]
["Wrestling",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
[]
["Women's Sports"]
["Basketball",48000,52000,46000,{"$f":"ROUND(C22+(C22*F22),-2)","v":49400},-0.05,54300,0.1,59700,0.1,65700,0.1,72300,0.1]
["Field Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Golf",0,0,0,0,null,0,null,0,null,0,null,0]
["Gymnastics",0,0,0,0,null,0,null,0,null,0,null,0]
["Ice Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Lacrosse",0,0,0,0,null,0,null,0,null,0,null,0]
["Soccer",6000,8800,7500,8400,-0.05,9200,0.1,10100,0.1,11100,0.1,12200,0.1]
["Softball",1800,2200,1800,2100,-0.05,2300,0.1,2500,0.1,2800,0.1,3100,0.1]
["Swimming",3200,6000,4000,5700,-0.05,6300,0.1,6900,0.1,7600,0.1,8400,0.1]
["Tennis",1800,2000,2000,1900,-0.05,2100,0.1,2300,0.1,2500,0.1,2800,0.1]
["Track and Field",1800,1800,1500,1700,-0.05,1900,0.1,2100,0.1,2300,0.1,2500,0.1]
["Volleyball",3200,20000,3000,19000,-0.05,20900,0.1,23000,0.1,25300,0.1,27800,0.1]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
[]
["Total Official Fees",{"$f":"SUM(B6:B35)","v":256000},297850,234300,283100,null,316400,null,353900,null,396400,null,444700]

{"sheet":"Medical Expenses","index":31,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Medical Expenses and Insurance"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
[]
["Insurance claims collected",360000,402000,350000,{"$f":"ROUND(C5+(C5*F5),-2)","v":442200},0.1,486400,0.1,535000,0.1,588500,0.1,647400,0.1]
["Other Medical Expenses",120000,150000,100000,157500,0.05,165400,0.05,173700,0.05,182400,0.05,191500,0.05]
[]
[]
["Total Medical Expenses",{"$f":"SUM(B5:B8)","v":480000},552000,{"$f":"SUM(D5:D8)","v":450000},599700,null,651800,null,708700,null,770900,null,838900]

{"sheet":"Guarantees-Exp","index":32,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Guarantees"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
[]
["Football",210000,240000,230000,{"$f":"ROUND(C5+(C5*F5),-2)","v":252000},0.05,264600,0.05,277800,0.05,283400,0.02,289100,0.02]
["Men's Basketball",65000,70000,65000,73500,0.05,77200,0.05,81100,0.05,82700,0.02,84400,0.02]
["Women's Basketball",45000,50000,45000,52500,0.05,55100,0.05,57900,0.05,59100,0.02,60300,0.02]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
[]
[]
["Total Guarantees-Expenses",{"$f":"SUM(B5:B13)","v":320000},360000,{"$f":"SUM(D5:D13)","v":340000},378000,null,396900,null,416800,null,425200,null,433800]

{"sheet":"Direct Facilities","index":33,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Direct Costs for Facilities, Maintenance, Rental, etc."]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
[]
["Building & grounds maintenance",180000,200000,150000,{"$f":"ROUND(C5+(C5*F5),-2)","v":202000},0.01,208100,0.03,214300,0.03,220700,0.03,227300,0.03]
["Direct debt service",400000,425000,330000,595000,0.4,612900,0.03,631300,0.03,650200,0.03,669700,0.03]
["Equipment repair & maintenance",98000,125000,110000,126300,0.01,130100,0.03,134000,0.03,138000,0.03,142100,0.03]
["Operating leases",10000,10000,8000,10100,0.01,10400,0.03,10700,0.03,11000,0.03,11300,0.03]
["Rental fees",4800,5000,4000,5100,0.01,5300,0.03,5500,0.03,5700,0.03,5900,0.03]
["Utilities",120000,130000,119000,131300,0.01,135200,0.03,139300,0.03,143500,0.03,147800,0.03]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
[]
["Total Facilities, Maintenance & Rental",{"$f":"SUM(B5:B12)","v":812800},895000,{"$f":"SUM(D5:D12)","v":721000},1069800,null,1102000,null,1135100,null,1169100,null,1204100]

{"sheet":"Indirect Facilities","index":34,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Indirect Costs for Facilities and Administrative Support"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
[]
["Administrative costs",0,0,0,{"$f":"ROUND(C5+(C5*F5),-2)","v":0},null,0,null,0,null,0,null,0]
["Facilities & maintenance",0,0,0,0,null,0,null,0,null,0,null,0]
["Grounds & field maintenance",0,0,0,0,null,0,null,0,null,0,null,0]
["Security",0,0,0,0,null,0,null,0,null,0,null,0]
["Risk management",0,0,0,0,null,0,null,0,null,0,null,0]
["Utilities",0,0,0,0,null,0,null,0,null,0,null,0]
["Depreciation",0,0,0,0,null,0,null,0,null,0,null,0]
["Indirect debt service",100000,100000,90000,110000,0.1,165000,0.5,247500,0.5,371300,0.5,519800,0.4]
[]
[]
["Total Indirect Facilities & Admin. Support",{"$f":"SUM(B5:B14)","v":100000},100000,{"$f":"SUM(D5:D14)","v":90000},110000,null,165000,null,247500,null,371300,null,519800]

{"sheet":"Fundraising","index":35,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Fundraising, Marketing & Promotion"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
[]
["Fundraising ",45000,50000,45000,{"$f":"ROUND(C5+(C5*F5),-2)","v":55000},0.1,60500,0.1,66600,0.1,73300,0.1,80600,0.1]
["Marketing",93000,125000,90000,131300,0.05,137900,0.05,144800,0.05,152000,0.05,159600,0.05]
["Promotion",20500,30000,18000,31500,0.05,33100,0.05,34800,0.05,36500,0.05,38300,0.05]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
[]
["Total Fundraising, Marketing & Promotion",{"$f":"SUM(B5:B11)","v":158500},205000,{"$f":"SUM(D5:D11)","v":153000},217800,null,231500,null,246200,null,261800,null,278500]

{"sheet":"Sports Camp Exp.","index":36,"n_rows":42,"n_cols":14,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Sports Camp Expenses"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
[]
["Expenses"]
["Men's-Boy's Sports"]
["Basketball",31000,50000,35000,{"$f":"ROUND(C7+(C7*F7),-2)","v":52500},0.05,55100,0.05,57900,0.05,60800,0.05,63800,0.05]
["Baseball",34000,35600,30000,37400,0.05,39300,0.05,41300,0.05,43400,0.05,45600,0.05]
["Football",70000,75000,65000,78800,0.05,82700,0.05,86800,0.05,91100,0.05,95700,0.05]
["Gymnastics",0,0,0,0,null,0,null,0,null,0,null,0]
["Golf",0,0,0,0,null,0,null,0,null,0,null,0]
["Ice Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Lacrosse",0,0,0,0,null,0,null,0,null,0,null,0]
["Soccer",9000,9800,9000,10300,0.05,10800,0.05,11300,0.05,11900,0.05,12500,0.05]
["Swimming",5800,6000,6000,6300,0.05,6600,0.05,6900,0.05,7200,0.05,7600,0.05]
["Tennis",0,0,0,0,null,0,null,0,null,0,null,0]
["Track and Field",0,0,0,0,null,0,null,0,null,0,null,0]
["Volleyball",0,0,0,0,null,0,null,0,null,0,null,0]
["Wrestling",0,0,0,0,null,0,null,0,null,0,null,0]
["Strength",null,null,null,0,null,{"$f":"ROUND(E20+(E20*H20),-2)","v":0},null,{"$f":"ROUND(G20+(G20*J20),-2)","v":0},null,{"$f":"ROUND(I20+(I20*L20),-2)","v":0},null,{"$f":"ROUND(K20+(K20*N20),-2)","v":0}]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
[]
["Women's-Girls Sports"]
["Basketball",22000,25000,20000,{"$f":"ROUND(C24+(C24*F24),-2)","v":26300},0.05,27600,0.05,29000,0.05,30500,0.05,32000,0.05]
["Field Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Golf",0,0,0,0,null,0,null,0,null,0,null,0]
["Gymnastics",0,0,0,0,null,0,null,0,null,0,null,0]
["Ice Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Lacrosse",0,0,0,0,null,0,null,0,null,0,null,0]
["Soccer",9100,9800,9000,10300,0.05,10800,0.05,11300,0.05,11900,0.05,12500,0.05]
["Softball",11800,12500,12000,13100,0.05,13800,0.05,14500,0.05,15200,0.05,16000,0.05]
["Swimming",3500,6000,5000,6300,0.05,6600,0.05,6900,0.05,7200,0.05,7600,0.05]
["Tennis",0,0,0,0,null,0,null,0,null,0,null,0]
["Track and Field",0,0,0,0,null,0,null,0,null,0,null,0]
["Volleyball",0,20000,0,21000,0.05,22100,0.05,23200,0.05,24400,0.05,25600,0.05]
["Cheerleading",null,null,null,0,null,{"$f":"ROUND(E36+(E36*H36),-2)","v":0},null,0,null,{"$f":"ROUND(I36+(I36*L36),-2)","v":0},null,{"$f":"ROUND(K36+(K36*N36),-2)","v":0}]
["Dance",null,null,null,{"$f":"ROUND(C37+(C37*F37),-2)","v":0},null,{"$f":"ROUND(E37+(E37*H37),-2)","v":0},null,{"$f":"ROUND(G37+(G37*J37),-2)","v":0},null,{"$f":"ROUND(I37+(I37*L37),-2)","v":0},null,{"$f":"ROUND(K37+(K37*N37),-2)","v":0}]
["Strength",null,null,null,{"$f":"ROUND(C38+(C38*F38),-2)","v":0},null,{"$f":"ROUND(E38+(E38*H38),-2)","v":0},null,{"$f":"ROUND(G38+(G38*J38),-2)","v":0},null,{"$f":"ROUND(I38+(I38*L38),-2)","v":0},null,{"$f":"ROUND(K38+(K38*N38),-2)","v":0}]
["Other",null,null,null,{"$f":"ROUND(C39+(C39*F39),-2)","v":0},null,{"$f":"ROUND(E39+(E39*H39),-2)","v":0},null,{"$f":"ROUND(G39+(G39*J39),-2)","v":0},null,{"$f":"ROUND(I39+(I39*L39),-2)","v":0},null,{"$f":"ROUND(K39+(K39*N39),-2)","v":0}]
[]
[]
["Total Sports Camp Expenses",{"$f":"SUM(B7:B41)","v":196200},249700,{"$f":"SUM(D7:D41)","v":191000},262300,null,275400,null,289100,null,303600,null,318900]

{"sheet":"Spirit Groups","index":37,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Spirit Group Expenses"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
[]
["Cheerleaders",5500,6000,5000,{"$f":"ROUND(C5+(C5*F5),-2)","v":6300},0.05,6600,0.05,6900,0.05,7200,0.05,7600,0.05]
["Dance squad",2000,3000,2500,3200,0.05,3400,0.05,3600,0.05,3800,0.05,4000,0.05]
["Band",10000,12000,8000,12600,0.05,13200,0.05,13900,0.05,14600,0.05,15300,0.05]
["Mascot",800,1000,800,1100,0.05,1200,0.05,1300,0.05,1400,0.05,1500,0.05]
["Other"]
[]
[]
["Total Spirit Group Expenses",{"$f":"SUM(B5:B11)","v":18300},22000,{"$f":"SUM(D5:D11)","v":16300},23200,null,24400,null,25700,null,27000,null,28400]

{"sheet":"Memberships & Dues","index":38,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Memberships & Dues"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
["Association dues"]
["Men's Sports"]
["Basketball",11000,12850,12000,{"$f":"ROUND(C6+(C6*F6),-2)","v":13700},7.0000000000000007E-2,14700,7.0000000000000007E-2,15700,7.0000000000000007E-2,16800,7.0000000000000007E-2,18000,7.0000000000000007E-2]
["Baseball",6000,9000,8000,9500,0.05,10000,0.05,10500,0.05,11000,0.05,11600,0.05]
["Football",60000,82450,80000,86600,0.05,90900,0.05,95400,0.05,100200,0.05,105200,0.05]
["Gymnastics",0,0,0,0,null,0,null,0,null,0,null,0]
["Golf",3200,3300,3100,3300,null,3300,null,3300,null,3300,null,3300]
["Ice Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Lacrosse",0,0,0,0,null,0,null,0,null,0,null,0]
["Soccer",6000,6800,6500,6800,null,6800,null,6800,null,6800,null,6800]
["Swimming",3200,3700,3200,3700,null,3700,null,3700,null,3700,null,3700]
["Tennis",1800,2000,1500,2000,null,2000,null,2000,null,2000,null,2000]
["Track and Field",0,0,0,0,null,0,null,0,null,0,null,0]
["Volleyball",0,0,0,0,null,0,null,0,null,0,null,0]
["Wrestling",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Association dues"]
["Women's Sports"]
["Basketball",6000,7000,7200,{"$f":"ROUND(C22+(C22*F22),-2)","v":7500},7.0000000000000007E-2,8000,7.0000000000000007E-2,8600,7.0000000000000007E-2,9200,7.0000000000000007E-2,9800,7.0000000000000007E-2]
["Field Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Golf",0,0,0,0,null,0,null,0,null,0,null,0]
["Gymnastics",0,0,0,0,null,0,null,0,null,0,null,0]
["Ice Hockey",0,0,0,0,null,0,null,0,null,0,null,0]
["Lacrosse",0,0,0,0,null,0,null,0,null,0,null,0]
["Soccer",6000,8800,8000,9200,0.05,9700,0.05,10200,0.05,10700,0.05,11200,0.05]
["Softball",1800,2250,2000,2300,null,2300,null,2300,null,2300,null,2300]
["Swimming",3200,6000,5000,6000,null,6000,null,6000,null,6000,null,6000]
["Tennis",1800,2000,2100,2000,null,2000,null,2000,null,2000,null,2000]
["Track and Field",1800,1800,1900,1800,null,1800,null,1800,null,1800,null,1800]
["Volleyball",3200,3400,3000,3400,null,3400,null,3400,null,3400,null,3400]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
[]
["Conferences",5000,6000,5000,{"$f":"ROUND(C36+(C36*F36),-2)","v":6000},null,6000,null,6000,null,6000,null,6000]
["Memberships",650,700,600,700,null,700,null,700,null,700,null,700]
[]
[]
["Total Memberships & Dues",{"$f":"SUM(B6:B39)","v":120650},158050,{"$f":"SUM(D6:D39)","v":149100},164500,null,171300,null,178400,null,185900,null,193800]

{"sheet":"Other Expenses","index":39,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Other Expenses"]
[null,null,"Current Year","Current Year"]
[null,"Previous Year","Budget","Actual","Year 1","Yr1  %","Year 2","Yr2  %","Year 3","Yr3  %","Year 4","Yr4  %","Year 5","Yr5  %"]
[]
["Other",0,0,0,{"$f":"ROUND(C5+(C5*F5),-2)","v":0},null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
["Other",0,0,0,0,null,0,null,0,null,0,null,0]
[]
[]
["Total Other Expenses",{"$f":"SUM(B5:B10)","v":0},0,0,0,null,0,null,0,null,0,null,0]

{"sheet":"Rev.vs. Exp","index":40,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Graphs","index":41,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Empty Sheet","index":42,"n_rows":3,"n_cols":11,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,1,0,10]]}
[null,"Empty Sheet"]
[null,null,null,"Current Year","Current Year","Projected"]
[null,"Previous Year","Previous Year","Budget","Actual","Year End","Year 1","Year 2","Year 3","Year 4","Year 5"]